Hello,
I wrote/recorded this macro recently but there a few things I couldn't make it do that I wanted to. Also, I am sure that it could be improved by someone with more VBA knowledge than myself.
Here are two things I really would like the macro to do:
1) Instead of pasting the formula into cells O2:O30000, I would like to paste the formula into cells O2 until the last row of data. My files have anywhere from 100 records to 25,000 or so. I choose 30000 because I knew if would be long enough, but it is pasting formulas in cells where I don't want/need formulas...
2) Instead of pasting formulas into cells O2:O30000, I would like to paste the value calculated be the formula.
There is a third thing I would like the macro to do, although I am not sure it is as important as the first two.
3) When I select the rows that say "Delete" in column O, I get an error message if there are no "Delete"s in that column. I made the error message say "No Records to Delete" which works, but I am wondering if there is a way to do this without getting an error message.
Thanks in advance of anyone who can give me ANY help on this.
Bookmarks