Hi
Using the above notation:
Sheets(x).Range(xx).select produce a run time error 1004 select method of range class failed.
I have a VBA taking data from sheets(x).range(x) and placing it in sheets
.range
What should be the correct notation for this simple task?
Using the above notation:
Sheets(x).Range(xx).select produce a run time error 1004 select method of range class failed.
I have a VBA taking data from sheets(x).range(x) and placing it in sheets


What should be the correct notation for this simple task?