| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
delete range using VBA
Hello
I get a daily report from an outside vendor which I copy and paste into my report. On columns AH and AI, I have added formulas to determine if the payment is late and the amount due I want to delete the range starting in row 5 to column AG till the last row that has information. I do not want to delete the formulas on column AH and AI so they will calculate. I tried Sub Clear141() ' ' Clear141 Macro ' Range("A5:AG3424" & Count).Select Selection.ClearContents End Sub This seems to work but is it the best way to do it. thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Delete blanks between a range and populate only the names inthe given range | Excel Discussion (Misc queries) | |||
| delete a range | Excel Worksheet Functions | |||
| How to Delete a Range in Closed Workbook (to Replace Delete Query) | Excel Discussion (Misc queries) | |||
| delete every nth row in selected range | Excel Discussion (Misc queries) | |||
| How to delete the print range | Excel Discussion (Misc queries) | |||
Threaded Mode
