| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Referencing Different Sheets in VBA
Hi,
How can I make refer to a cell in a certain worksheet (say the 3rd one listed), without referring to it by name, as it will vary? I'd like to be able to do this in formulas in Visual Basic, so basically say: Cells(1,1).Value = Sheets("[name]").Cells(1,1).Value Thanks! Brett |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Referencing other sheets - updates | Excel Discussion (Misc queries) | |||
| Excel referencing across sheets | Excel Discussion (Misc queries) | |||
| Copying formulas referencing multiple sheets | Excel Worksheet Functions | |||
| Formulas referencing other sheets | Excel Discussion (Misc queries) | |||
| Referencing Sheets in a Formula | Excel Discussion (Misc queries) | |||
Threaded Mode
