?
Solved

VBA Formula

Posted on 2013-11-18
3
Medium Priority
?
222 Views
Last Modified: 2013-11-18
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
Comment
Question by:Seamus2626
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 23

Accepted Solution

by:
NBVC earned 2000 total points
ID: 39656807
Something like:

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

Open in new window

0
 
LVL 10

Expert Comment

by:Anthony Berenguel
ID: 39656828
Is the sheet 'Calculation D2' in the same workbook as the sheet in which you're trying to apply this formula?
0
 

Author Closing Comment

by:Seamus2626
ID: 39656838
Thanks NB_VC
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This article describes a serious pitfall that can happen when deleting shapes using VBA.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question