Selection.Clear

[MikeM]

I have the following macro that for some reason does not work in Excel 2003?
It was created in Excel 2000 and worked fine? Here is a portion of the Macro.
The Selection.Clear does not Clear the "clearme" named range?
Any idea's?


Application.ScreenUpdating = False
Application.Goto Reference:="clearme"
Selection.Clear
Range("D12").Select
If Worksheets("1. Segment Prioritization").Range("S11") = 1 Then
Sheets("Seg (1)").Select
.........

 

[JE McGimpsey]

I have the following macro that for some reason does not work in Excel 2003?
It was created in Excel 2000 and worked fine? Here is a portion of the Macro.
The Selection.Clear does not Clear the "clearme" named range?
Any idea's?


Application.ScreenUpdating = False
Application.Goto Reference:="clearme"
Selection.Clear
Range("D12").Select
If Worksheets("1. Segment Prioritization").Range("S11") = 1 Then
Sheets("Seg (1)").Select
........

Works fine for me in MacXL 2004 (you've posted in a MacXL newsgroup),
and I see no reason that it shouldn't work in WinXL03.

How is the "clearme" range defined?

What does "does not work" mean to you - do you get an error? Nothing? a
crash?

 

[MikeM]

Sorry about wrong posting. I'll sent to Post it onto correct group.

FYI - I get no error message, it simple does not "clear" the data from the
Range.

If I rewrite the macro to :
worksheets("sheet1").range("A2:iv65536").clearcontents
ir runs fine!