Problems clearing a cell

[Ralph Private]

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("P3898").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

 

[Eddy]

Are there any merged cells in the column of "N", "P" and "R"?

 

[Sander Lablans]

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("P3898").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

What happens when you run your code from the VB-editor using the function
key "F8"? Does it go through the lines correctly?

Perhaps you should use something like:

activesheet.range("...").clear

or

activesheet.range("...").clearcontents

SL

 

[Ralph van Mulken]

No the celles are not merged

Are there any merged cells in the column of "N", "P" and "R"?