Hi,
I am working on a way to copy data from my activeworksheet to an indirectly addressed worksheet + colum + row, according to cell data on my sheet. Problem is just that I cant seem to get it past the copy process...
B1 is the sheet name
D1 is the colum number
D2 is the row number (which is always row 167).
Anyone who can help with that?
Please Login or Register to view this content.
Thank you,
A2k
Hi, Armitage2k,
you are setting your objects to the ActiveSheet not to the addressed one.
And I would set the Range for the starting cell in one trake instead of having to set it up again from a column and a row:Please Login or Register to view this content.
Maybe just tryPlease Login or Register to view this content.
for copying over just values orPlease Login or Register to view this content.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks