runtime error 9 out of range 1

[butchkmd]

I used this line in my code
Worksheets("worksheet6(R S Cont.(2))&quot!Range!(T33:AI33&quot.Value = ""

and I get the error "out of range"

the cell range is there on ws6 I don't get it any suggestions?

Thanks
Matt

 

[SkipVought]

Hey butch,

Two problems...
1. Need QUOTES around your range
2. No !
Worksheets(1).Range("T33:AI33&quot.Value = "" Skip,
metzgsk@voughtaircraft.com

 

[LSTAN]

Hi

Try changing to this;


Worksheets("worksheet6(R S Cont.(2))&quot.Range("T33:AI33&quot.Value = ""

Hope this helps.

rgds
LSTAN

 

[butchkmd]

I changed it to this
Sheet6!Range("T33:AH33&quot.Value = ""
I get an error that the object does not support this property or method.

AAAAAHHHHHHHHHHHHHHH!!!!!!!!!!!!!![MAD]


All I need to do is clear the range and replace the text
The replace works using .value = what do I use to clear it?


I'm really starting to not like Excel

But I do like you guys!

 

[SkipVought]

READ MY LIPS....

No "!"

NOT...
Sheet6!Range("T33:AH33&quot.Value = ""

BUT...
Sheet6.Range("T33:AH33&quot.Value = "" Skip,
metzgsk@voughtaircraft.com

 

[butchkmd]

Roger Doger

Tankx