Is this possible?
I have a name of a worksheet in column K.
Below is a sippet of my code. If I change the part Ptr, "K" to an an actual name of a worksheet the code runs. However, I have the name of a sheet in the cell Ptr, "K" and it doesn't run.
Please help. Thanks!
Please Login or Register to view this content.
But this code works...
Please Login or Register to view this content.
Last edited by ScabbyDog; 03-30-2014 at 10:52 AM.
Full code if you guys need it
So i want to paste the row into the sheet name that is listed in column K on the row.Please Login or Register to view this content.
Hi, ScabbyDog,
reason maybe that you try and create a range object but want to refer to the entire range thereafter on basis of a sinlgle value
Ciao,Please Login or Register to view this content.
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Excellent HaHoBe.
Greatly appreciated.
Hi, ScabbyDog,
please revert the loop to start at the bottom and work up like
because otherwise the row counter may skip rows when going down as the row number has already been checked.Please Login or Register to view this content.
Ciao,
Holger
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks