• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 235
  • Last Modified:

VBA Formula

Hi,

I havent entered formula ino the editor in a while

= VLOOKUP(B2,'Calculation D2'!A:BG,29,0)

Im getting an error with the apostrophy before calculation, can anyone advise?

Thanks
Seamus
0
Seamus2626
Asked:
Seamus2626
1 Solution
 
NBVCCommented:
Something like:

Range("A1").Formula = "=VLOOKUP(B2,'Calculation D2'!A:BG,29,0)"

Open in new window

0
 
Anthony BerenguelCommented:
Is the sheet 'Calculation D2' in the same workbook as the sheet in which you're trying to apply this formula?
0
 
Seamus2626Author Commented:
Thanks NB_VC
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now