I need to create a macro to run if in column D equals "2529-3" or "other" to delete those rows. The will be used for an entire sheet. For some reason I get the error subscript is out of range for the one I tried to write. TIA.
I need to create a macro to run if in column D equals "2529-3" or "other" to delete those rows. The will be used for an entire sheet. For some reason I get the error subscript is out of range for the one I tried to write. TIA.
Subscript error means you're trying to access named object that cannot be located by that name. For instance if your code were looking for a "Sheet 1" but it was really called "Sheet1" they would not match and give that error. Look in your code for named objects and see if you can spot the typo.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon 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!)
Maybe:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks