View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ralph Private Ralph Private is offline
external usenet poster
 
Posts: 1
Default Problems clearing a cell

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