ExcelBanter - VBA Formulae...

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - VBA Formulae... (https://www.excelbanter.com/excel-programming/383487-vba-formulae.html)

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

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

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