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
|