So, when I call BBB, I must call it as follows:

BBB Sheet3 ' works okay

On the other hand, I get an error message if I call it as follows:

BBB (Sheet3) ' error message - Object doesn't support this property or
message.

I just think it's weird that an error occurs if I place parentheses around
Sheet3. I wonder
why that causes an error?

Anyways, thank you so much for your help. Your solution above DOES work
for my needs!


"Chip Pearson" wrote in message
...

Declare the parameter As Worksheet. E.g,

Sub AAA()
BBB Sheet3
End Sub

Sub BBB(WS As Worksheet)
Debug.Print WS.Name, WS.Range("A1").Text
End Sub