Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I select a range using a macro?
Via macro, I would like to delete all rows that have a value of one (1) in
column H. All rows that have a value of (1) will be contiguous, meaning they will follow one after the other (they won't be separate by rows in between that do not have a value of (1) in column H); however, where the rows with a value of (1) begin and end will vary each time the macro is used. For example, rows 1 through 10 will not have a value of (1) in column H, but rows 11 through 14 will. The next time the macro is run, it may be that rows one through eight won't have a value of (1) in column H, but rows nine through eleven will. I'd like the macro to identify these rows with a value of (1) in column H, select just those rows, and delete them. Thanks for the help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro help | Excel Discussion (Misc queries) | |||
Range Name affecting speed of macro | Excel Worksheet Functions | |||
Copy/Paste using a macro that identifies occuoied range | Setting up and Configuration of Excel | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
Match function...random search? | Excel Worksheet Functions |