Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 :) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
excel sheet bootom half sheet goes behind top part of sheet | Excel Worksheet Functions | |||
Duplicate sheet, autonumber sheet, record data on another sheet | Excel Worksheet Functions | |||
How do I select price from sheet.b where sheet.a part no = sheet.b | Excel Worksheet Functions | |||
Copying cells from on sheet to another sheet (via sheet module) | Excel Programming | |||
Inserting a row in sheet A should Insert a row in sheet B, removing a row in Sheet A should remove the corresponding row in sheet B | Excel Programming |