Hello,
I have below code which is working up till the code highlighted in red, which really meant to select the cell where the corresponding invoice is located on the worksheet.
I'm not sure why do I get the runtime error 1004 as per the title since I am just selecting it.
Thank you very much for your help and input.
Please Login or Register to view this content.
Is salesWks active when you select the range in code?
If not, try activating it first before selecting a range in the sheet.
Please Login or Register to view this content.
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
You're right CK76, I completely overlooked that important step. All working now.
Thank you ever so much.
You are welcome and thanks for the rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks