| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro to enter zero into 240 ranges?
I wish to enter the value zero into various ranges within my spreadsheet.
(Wiping clean all prior data entries across the spreadsheet, so that the next project can start.) e.g. A7:L21, A25:L37, A42:L57, P7:AB21, P25:AB37, etc etc There are currently 240 such ranges. Do these need to be named? Presumably some VBA code is the answer...can someone suggest something please? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to select cells in column enter data then press enter | New Users to Excel | |||
| Macro Ranges | Excel Discussion (Misc queries) | |||
| How can I stop Excel from turning the number ranges I enter (eg 1. | New Users to Excel | |||
| macro to change date ranges | Excel Discussion (Misc queries) | |||
| Relative Ranges in excel macro | Excel Discussion (Misc queries) | |||
Threaded Mode
