Vlookup vb

[bassinator]

Good day everyone,

I seek someone's experience,

I'm trying to create a bLastRecon = "FilePath" within the following:

"=VLOOKUP(RC[-6], 'S:\[BASS8.xlsx]P8'!C4:C10,7,FALSE)"

Any help?

I've tried the following without success,
'No good
' "=VLOOKUP(D4, 'S:\[BASS8.xlsx]P8'!D4:J10,7,FALSE)"
' "=VLOOKUP(D4, '(bLastRecon)'!$D:$J,7,FALSE)"
' "=VLOOKUP(RC[-6], '(bLastRecon)'!C4:C10,7,FALSE)"

[6StringJazzer]

What is the nature of the failure? Does it compile? Does it run to completion with the wrong result in the worksheet? Does it stop with an error?

[bassinator]

What is the nature of the failure? Does it compile? Does it run to completion with the wrong result in the worksheet? Does it stop with an error?

Script works fine, but I want to be able to modify the path at the top instead at the Vlookup function within the code

"=VLOOKUP(RC[-6], 'S:\[BASS8.xlsx]P8'!C4:C10,7,FALSE)" <--- this works fine but I will need to change it manually within the code to P9 next time and the next time P10 etc. which is why I am seeking help in suggestions in coding this to reflect at the top level of the code bLastRecon = "S:\[BASS8.xlsx]P8"

I've tried to remove the brackets from "=VLOOKUP(RC[-6], '(bLastRecon)'!C4:C10,7,FALSE)" but it fails to work at all, makes me open 2 times the actual file that i need to browse for it to load and also doesn't work at all and comes with #NAME instead of the usual #N/A with the normal script. Some people put the variables with v, i put a b instead (bLastRecon)

Let me know if you know what I mean by this,

Thank you in advance

[6StringJazzer]

If bLastRecon is a variable then you want

Please Login or Register  to view this content.

See correction below, extra quote marked above

[bassinator]

If bLastRecon is a variable then you want

Please Login or Register  to view this content.

Thx 6String !, I will test first thing on Monday and come back to confirm if it works,

Keep you posted

[6StringJazzer]

I didn't take the time to test this, but I just saw an error. There was an extra double-quote mark, after the first comma:

Please Login or Register  to view this content.

[bassinator]

Works great 6StringJazzer ! Thank you for your help

[6StringJazzer]

Glad to hear it! You're very welcome.