Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
greetings
I have code that generates names (eg T2_Master) Dim TaskWSName as String TaskWSName = "T" & ActiveSheet.Range(E8) & "_Master" Later, I want to have code that refers to Worksheets having these names. Here's an eg: Worksheets("PrintReport").Range("A1").Formula = "=INDEX(T2_Master!E:E,MATCH(A8,T2_Master!A:A,0 )) How do I refer to T2_Master! in the INDEX or the MATCH statements? Using TaskWSName! doesn't work. Thanks in advance anny |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA syntax question | Excel Discussion (Misc queries) | |||
Syntax Question | Excel Programming | |||
syntax question | Excel Programming | |||
Easy Syntax question: referring to worksheet by VBA name | Excel Programming | |||
VBA Syntax Question? | Excel Programming |