I'm a beginner when it comes to VBA so any help would be really appreciated.
I'm trying to copy a line of cells into another tab within the same workbook. I need the code to find the first empty cell in a row and then paste the data as values in that empty cell. I have added in the range as it is as previously I was having errors with using "B:B"
I have done the below but keep getting the Application-defined or object-defined error
Please Login or Register to view this content.
Last edited by AliGW; 08-17-2023 at 08:03 AM.
I have also tried Range("b" & Rows.Count).End(xlUp).Select instead of the if statement, but receive the same error which makes me believe that the issue is within the sheet selection
Welcome to the forum.
Please review the forum rules.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
My apologies, I forgot to add the code into a coded view. New to all of this.
This is what I ended up going with
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks