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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Formulae...
Hi Mark
Try this: First.Formula = "=VLOOKUP(" & FirstB.Address(False,False) & ", 'download.csv'!$A$2:$J$5000,10,FALSE)" Hope this helps! Richard On 19 Feb, 09:20, "MarkHear1" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Formulae...
On Feb 19, 9:29 am, "RichardSchollar"
wrote: Hi Mark Try this: First.Formula = "=VLOOKUP(" & FirstB.Address(False,False) & ", 'download.csv'!$A$2:$J$5000,10,FALSE)" Hope this helps! Richard On 19 Feb, 09:20, "MarkHear1" wrote: 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- Hide quoted text - - Show quoted text - Richard, thank you very much - that's brilliant :-) Regards, Mark |
Reply |
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 |