Quicky! ActivateWorksheet.

[antman123]

Hi there (my first ever post!)

Pretty basic, but annoying me! How do I activate a particular worksheet? I have made a VBA procedure that uses only one worksheet, so i need to activate it at the start of the routine. Any help will be much appriciated. Thanks

 

[P Sitaram]

If you really need to activate:

worksheets("name").activate

Otherwise

With Worksheets("name")
....code....
End With

is a better option.

 

[cherria]

Welcome.

You use worksheet("worksheetname").activate

where worksheetname is the name on the worksheet tab eg. Sheet1

 

[jindon]

Hi,
if you have only one worksheet then

Sheets(1).Activate

or

Sheets("YourSheetName").Activate

do you really need to activate the sheet when you have only one sheet?

rgds,
jindon

 

[antman123]

Thanks guys. I have more then one sheet... Its just for the sub routine i am using at that point only uses one particular worksheet.