access function in data sheet(another sheet)
Hi VBA excel gurus
I have searched on google and different forums but could not find answer. I am looking for how to call Public function in a sheet "Data-Sheet" from another sheet "OutputSheet". I have tried the following code which didn't work for me.
'in OutputSheet
dim s as string
Dim ws as worksheet
set ws=worksheet("Data-Sheet")
s=ws.GetHeadingDetails 'Where GetHeadingDetails is a fucntion.
Please reply ASAP. I am running late for this project. .....tight deadline plzzzzzzz
Ramzan
|
