vba macro day 2

[Guest]

Yesterday we had the folowing below conversation, but I am confused what you mean by your second part that I need to handle the argument something like............

Thanks





Public sub workbook_open()

call Macro18("Sheet1")
call Macro41("Sheet2")

end sub

but you would need to handle the argment, something like

Sub Macro18(sh as String)
With Worksheets(sh)
...
End With
End Sub

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Don Guillett]

You should stay in the original thread and follow instructions of those
trying to help you.

--
Don Guillett
SalesAid Software
(e-mail address removed)

Yesterday we had the folowing below conversation, but I am confused what

you mean by your second part that I need to handle the argument something
like............