I am trying to put the following lines in a macro. If I replace the concatenation with a specific value (i.e. 9617) it works just fine. I don't understand why it is not working as listed. I get a Run-time error '1004': Method 'Range' of object_'Global' failed.
Any suggestions would be appreciated. I know I am missing something dumb.Please Login or Register to view this content.
Thanks,
Dave
Bookmarks