I can't seem to get rid of this error.
The line in red is where I get the error.
Please Login or Register to view this content.
I've tried the macros separately and it works just fine but the above code is part of a larger macros, this is when it's problematic.
I've attached an example excel file for reference. I appreciate the help, thank you!
It errors on row 1. You can't cut row 1 and insert it back at row 1.
You don't need to check row one anyway. Start your loop at row 2
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Thank you for your reply. I tried starting at row 2 and it doesn't insert the row at all. I'm confused now.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks