| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clear a range of data
I know I can use the code below to clear data from a range, but I need to
clear data from rng(1, 43) through rng(1, 125). Is there any way to do that without having to write a line for each rng to be cleared? Sub ClearData() Dim rng Set rng = Cells(ActiveCell.Row, 1) rng(1, 43).Value = "" End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Clear Range | Excel Programming | |||
| Sub to clear range above n below diagonal | Excel Programming | |||
| clear range of cells if another becomes blank | Excel Worksheet Functions | |||
| Clear Contents of a Selected Range | Excel Programming | |||
| Clear data range, and copy static value. | Excel Programming | |||
Threaded Mode
