I'm trying to copy a range B3:B354 from multiple different sheets into a master sheet
So the master sheet will open the new sheet, copy the range into B3:B354 then close the sheet
and move to the next one then copy the range b3:354 to C3:C354 I'm having issue with getting it
to copy the value's over.... please help Code is below.
Please Login or Register to view this content.
ThisWorkbook is the Workbook where the program resides - you'll need to change that!
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Change it to what? don't I need to tell it where to copy the information too?
Try this -(I'm wrong about ThisWorkbook)
You don't need the With..End With in this case.Please Login or Register to view this content.
Last edited by xladept; 08-23-2012 at 01:53 AM.
Doesn't copy anything. Doesn't toss an error either though... Though should it only target the top cell for the paste? or should it do the range again?
I got it to work with
Please Login or Register to view this content.
When you use copy that way it only needs the leading cell in the range. Glad you got it to work. Surprised that my code didn't work - did you get rid of the With...End With for Thisworkbook, because, if you didn't then you'd have needed a dot before Cells i.e.Please Login or Register to view this content.
Last edited by xladept; 08-23-2012 at 01:48 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks