Good morning,
I'm stumped what I'm doing wrong.
I know the following work and give the same result.
The problem I'm having is when I add in the name of a worksheet.
I'm stumped what I'm doing wrong.
I know the following work and give the same result.
VBA Code:
Set rng1 = Range("A5:A11")
Set rng2 = Range(Cells(5, 1), Cells(11, 1))
The problem I'm having is when I add in the name of a worksheet.
VBA Code:
Set rng1 = Sheets("Continuous Learning Details").Range("A5:A11") 'This works perfectly
Set rng2 = Sheets("Continuous Learning Details").Range(Cells(5, 1), Cells(11, 1)) 'This gives me an error code 1004, Application-defined or object-defined error