with statement error?

[zabiullakhan]

this works

With Sheet1
 
End With

This dosent, As test is my sheet name

With test
 
End With

Please help

 

[pedie]

[/FONT]
[FONT=Courier New]With Sheets("test")[/FONT]
[FONT=Courier New] [/FONT]
[FONT=Courier New]End With[/FONT]
[FONT=Courier New][/FONT] 
[FONT=Courier New]or [/FONT]
[FONT=Courier New][/FONT] 
[FONT=Courier New]with Sheet1[/FONT]
[FONT=Courier New] 'or Sheet2 'this sheet name refers to the sheet name you can view only 'when pressed alt + f11 [I hope you know that:)][/FONT]
[FONT=Courier New][/FONT] 
[FONT=Courier New]end with[/FONT]
[FONT=Courier New]

 

[Trebor76]

Hi zabiullakhan,

Try this:

 With Sheets("test")
            
    End With

Regards,

Robert

 

[zabiullakhan]

Thandks a lot.. it works..