Problems clearing a cell

  • Thread starter Thread starter Ralph Private
  • Start date Start date
R

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("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
 
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
Click to expand...

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
 
Back
Top