I am trying to select a range using VBA and have run into run-time error '1004': Method 'Range' of object '_Global' failed.
If I write the code this way it works fine:
I have lastrow set this way:
But if I expand the range by writing the code this way:
I get the run-time error.
Anybody have an idea what I am doing wrong?
Thanks