View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] Amaninder.Saini@gmail.com is offline
external usenet poster
 
Posts: 1
Default 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 :)