Im looking to use a macro to delete the first few rows of a file, down to where 'Line' is listed as the cell value. It will always appear in Column A, but can vary between Rows 8-10. The below code deletes a fixed number of rows (9), but it needs to be flexible, should 'Line' appear in row 8 or 10. Any assitance would be greatly appreciated.
Thanks,
Please Login or Register to view this content.
Ray
This is how I would do that:
I really want to draw your attention to the red lines, when you record a macro, it records your human actions of selecting and activating. You'll need to start editing those multiple lines of code down to single fully formatted commands, selecting is only necessary if you're a human. VBA can simply "do it" if the command is complete.Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
I greatly appreciate your quick response JB. This code works great except that it deletes the row that has the cell value 'Line', I need this to be my first row. My apologies if that was unclear.
Thanks,
Ray
So vFIND.Row becomes vFIND.Row - 1
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks