Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have problems clearing a range of cells with a excel macro.
I am using excel 97. The code that I use is: Sub test() Range("N38:N98").Clear Range("P38:P98").Clear Range("R38:R98").Clear End Sub In most of my worksheet this works fine but in one worksheet this code does not work the macro aborts after having preformed the first line. The range n38:n98 is actually cleared but after doing this the macro stops without any messages. The cells are not protected in any way. I don't know what I am doing wrong, can anyone help me with this problem. greet Ralph |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Clearing a cell based on the value of another cell (INDIRECT data) without macros | About this forum | |||
Clearing cells without clearing formulas | Excel Discussion (Misc queries) | |||
Clearing a cell | Excel Discussion (Misc queries) | |||
clearing a cell | New Users to Excel | |||
Clearing a cell | Excel Discussion (Misc queries) |