Macro's goal: Copy selected range from File1 to the last row of a specified sheet in password-protected File2.
I'm at this point:
CompileError.png
I'm a total noob when it comes to coding so any and all input is appreciated.
Macro's goal: Copy selected range from File1 to the last row of a specified sheet in password-protected File2.
I'm at this point:
CompileError.png
I'm a total noob when it comes to coding so any and all input is appreciated.
Remove the quotation marks " after the variable lRow ...
And remove the ) at the end ...
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
Can't see rest of code but start by removing the red characters in code
Please Login or Register to view this content.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
Tagging the thread solved as I got the answers.
Most grateful to both of you.
Pleasure... Glad we could assist. Tx for rep +
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks