I am getting an error as Run time Error 1004 Method 'Range' object '_Worksheet 'failed. please help below is my code
Please Login or Register to view this content.
I am getting an error as Run time Error 1004 Method 'Range' object '_Worksheet 'failed. please help below is my code
Please Login or Register to view this content.
Last edited by arlu1201; 07-24-2013 at 07:23 AM. Reason: Use code tags in future.
Hi,
Untested but perhaps
Set rSearch = Sheet1.Range("g2:" & Range("g65536").End(xlUp).Address)
or
Set rSearch = Range(Sheet1.Range("g2"), Sheet1.Range("g65536").End(xlUp))
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks