It's not that bad to be fair, the fact that you used named ranges is better than 90%!ShaunWhite wrote: ↑Sun May 02, 2021 5:18 amGo easy on my code fragment Paul, my code comes straight from the days when manuals were elaboratly illustrated by monks. No joke, my first program was on punched card, using a teletype machine and a phone linked to a computer 20 miles away to run it on. And they say cloud computing is new.
Although you didn't declare SourceSheet so it's defined as a variant rather than a string
There's no need to use Call before a routine, that was discontinued about 20 years ago, you're showing your punchcard age
Worksheets I tend to declare the reference to them and am super explicit that its an Excel worksheet rather than using Sheets for example
Code: Select all
Dim objWs as Excel.Worksheet
Set objWs = Thisworkbook.worksheets("Bet Angel")