| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Having a formula reference a a range
I am trying to get a vlookup formula to reference a range name. The code is
below - I know it's gotta be possible, but I can't get it to work! Sub Macro1() ' ' Macro1 Macro ' Macro recorded 11/12/2004 by ' Dim shtdate As String Range("c1").Select Range("c1").Activate shtdate = InputBox("Enter date of sheet to reference") ActiveCell = shtdate Range("B7").Select ActiveCell = "=VLOOKUP($A7,shtdate!$A$3:$C$97,2,FALSE)" End Sub Any help would be greatly appreciated. Thanks - Paula |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Relative Range Reference in a sumifs formula | Excel Worksheet Functions | |||
| Cell reference in formula as range | Excel Discussion (Misc queries) | |||
| Formula to return the reference of a range of cells | Excel Discussion (Misc queries) | |||
| using a dummy cell to reference a range into a formula | Excel Discussion (Misc queries) | |||
| Reference range in formula problem | Excel Programming | |||
Threaded Mode
