Selection.Clear

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MikeM - 31 May 2007 21:10 GMT

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
........

Signature

MJM

Reply to this Message

JE McGimpsey - 31 May 2007 21:57 GMT

> 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.
[quoted text clipped - 8 lines]
> 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?

Reply to this Message

MikeM - 31 May 2007 22:13 GMT

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!

Signature

MJM

> > 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.
[quoted text clipped - 16 lines]
> What does "does not work" mean to you - do you get an error? Nothing? a
> crash?

Reply to this Message

Mac Forum / Applications / Excel / May 2007

Selection.Clear