The following code works in the Immediate Window as well as a regular module.
It identifies the next blank row within an Excel table on worksheet “Combined.” However, I need that row number in the worksheet code for a different worksheet and when I try and use it there I get a 1004 Error - "Method'Range'of object'_Worksheet' failed" I tried a couple things, but nothing works.Please Login or Register to view this content.
I would appreciate any suggestions on how to resolve the issue. Thanks.
Bookmarks