| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete Macro using Offset
I use a message box in my macro that delivers a cell address. This aspect of
the macro work well. The following line I think is the problem: ActiveCell.Offset(1, 0).Resize(1, 17).ClearContents It clears the row below the one required. Is Offset the correct way to go? AlexW |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro offset cell value and sum | Excel Discussion (Misc queries) | |||
| offset macro based on multiple criteria | Excel Discussion (Misc queries) | |||
| How can I delete a macro when the Delete button is not active? | Excel Worksheet Functions | |||
| How do i delete a macro in Excel 2003 when delete isn't highlight | Excel Discussion (Misc queries) | |||
| macro to search and replace with offset | Excel Discussion (Misc queries) | |||
Threaded Mode
