Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problems clearing a cell
Are there any merged cells in the column of "N", "P" and "R"?
"Ralph Private" ????? m... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problems clearing a cell
On 1 Aug 2003 00:52:17 -0700, Ralph Private wrote:
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 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problems clearing a cell
No the celles are not merged
Eddy wrote: Are there any merged cells in the column of "N", "P" and "R"? "Ralph Private" ????? m... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |