How to get sheet from sheet name
Hi everyone
I am using Sheet3.Cells(1, 1) to get some value from Sheet3 but Sheet3
can change if i insert new sheets . So is there any function that
retruns worksheet if i provides the sheet name.
so instead of using
varaible = Sheet3.Cells(attRow, attCol)
i can use
Dim sheet , varaible
sheet = unknowFunciton("data sheet") ' "data sheet" is the name
of Sheet3
varaible = sheet.Cells(1, 1)
Regards
Amaninder Saini :)
|