LinkBack URL
About LinkBacks
Not sure if I need to define something or if my formatting is just wrong. All I am trying to do is copy columns from two worksheets into one main worksheet.
Please Login or Register to view this content.
Please help!
Why am I getting an application-based/object-based error?
Not sure if I need to define something or if my formatting is just wrong. All I am trying to do is copy columns from two worksheets into one main worksheet.Please Login or Register to view this content.
Please help!
With out 1
Please Login or Register to view this content.
More likely
Please Login or Register to view this content.
you need to qualify all the ranges
Please Login or Register to view this content.
Josie
if at first you don't succeed try doing it the way your wife told you to
Thank you both, the answer was actually a combination of both of your responses:
Please Login or Register to view this content.
Yes with and end with is more accurate, but IF all the sheets are on the same workbook, this should also work.
Please Login or Register to view this content.
no because
will find the last used row in column D on the active sheet, not the required sheet (it's also missing the .Row part)Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks