Hi
Can anyone explain why I get a Excel VBA Runtime error 1004 "Select method of Range class failed" when I run the code below? Every time it runs it stops on the line shaded red below.
The only thing I can think of as to why it is causing an error is the range it is selecting has a frozen pane on the top row, would this cause a problem? I have tried changing it to A1:A10000 but it still produces an error. Can anyone help?Please Login or Register to view this content.
Thanks,
Jeskit
Bookmarks