Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Formulae...
I am using the below formula and it works a treat. However I want the
'FirstB.Address' to be input as a relative reference rather than the default absolute reference. Could anybody offer any help as to how I could do this? Many Thanks. First.Formula = "=VLOOKUP(" & FirstB.address & ", 'download.csv'!$A $2:$J$5000,10,FALSE)" Regards, Mark |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need formulae | Excel Discussion (Misc queries) | |||
Formulae: Paste value formulae after doing an average operation | Excel Discussion (Misc queries) | |||
Formulae | Excel Worksheet Functions | |||
formulae | Excel Discussion (Misc queries) | |||
Searching TEXT in formulae, rather than results of formulae | Excel Worksheet Functions |