I have a pretty basic macro that I copied of youtube to copy data from a set location in sheet 1 and paste into sheet 6
Please Login or Register to view this content.
Whenever I run the code it says it is out of range
And is it possible to add to the code to only copy the cells in that range if they have data entered in them?
The ranges are not the same size.
Inidentally try to get into the habit of using VBA sheet code names rather than sheet tab names. These are too easily changed and when they are any hard coded tab names will cause a macro to fail.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
That's working perfectly now, I changed Sheet 1 and Sheet 6 - and it's picking it up.
Thanks.
There are ways of copying just say cells with formulae or constants and I missed your last comment about only copying cells with data.
However if cells are blank and you copy those too isn't the result essentially the same as copying the whole range blanks constants and formulae included?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks