Rusman8872
New Member
- Joined
- May 14, 2020
- Messages
- 6
- Office Version
- 2013
- Platform
- Windows
Hello . Im working with a very large spreadsheet that I am mining out a small amount of data. In Columns Q thru T I have formulas that identify the data I don't need and then returns "Delete". I need some VBA code that will look in Rows Q through T and delete the entire row of any cell that contains "Delete". The sheet will always contain between 8k and 10k rows but never more that 10k.
I would appreciate any help that someone could help with some code to drop into my macro. I have tried to use a For\Next loop but am not able to get the syntax correct.
thanks
I would appreciate any help that someone could help with some code to drop into my macro. I have tried to use a For\Next loop but am not able to get the syntax correct.
thanks