*Using Excel Formulas in Macros*

N

Nadeem

Hi
I am trying to use an Excel formula "lookup" in a macro.
This macro find the last row in work sheet and then
calcualte the range for the lookup_vector and
Result_vector. These ranges are then stored in a range
varible and copied to string variable.
but when I use these variables i this formaula, this gives
an error #NAME?

ActiveCell.FormulaArray = "=LOOKUP(RC[-4], st_range_1,
st_range_2)"

I am wondering if you could help.

Many thanks,

Nadeem
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word macro that can call cells out of Excel for a find and replace 0
Median Formula not working properly 2
Macro 3
Macro auto fill formula 4
Macro to search range for a portion of a specific value and if findit - then paste formula in anothe 2
Copy down formula macro 3
Yet More Excel VBA Help Please 0
Convert numbers stored as text to numbers - Automatically - Macro 2

Top