Accessing worksheets in a loop

[bsb2013]

I'm trying to access each one of the worksheets in my workbook and pass the variable through the workbook to access each. Sorry if that was unclear. Basically

Dim mysheet as worksheet

For each mysheet in worksheets
Sheets(mysheet.name).select
next mysheet

but the line: sheets(mysheet.name).select has an error. I think it is because I need a string where I say mysheet.name.... Unfortunately, I have little experience with VBA and am used to Java. Is there an parallel action in VBA to retrieving a name from an object and passing it as a string parameter?

 

[njimack]

You normally don't need to select sheets to perform actions on them. Use something like this:

Dim mysheet as worksheet

For each mysheet in worksheets
With mysheet
.Range("A1").Font.Bold = True 'example - change to suit your requirements
End With
next mysheet

 

[bsb2013]

What if I was trying to do an action like hide all of the sheets?

 

[njimack]

What if I was trying to do an action like hide all of the sheets?

Well that would be impossible, since at least one sheet must be visible, but here's the code that you would need...

Dim mysheet as worksheet

For each mysheet in worksheets
mysheet.Visible = False
next mysheet