My first macro, uses Vlookup but doesnt update unless hit enter

  • Thread starter Thread starter James Cornthwaite
  • Start date Start date
J

James Cornthwaite

I have written the macro (my first!) as below

Function FindOldNominal(NomCode)

FindOldNominal = WorksheetFunction.VLookup(NomCode, range("IMPORTRANGE"), 5,
false)
End Function




This works fine... except..


If I alter the value in the defined range "ImportRange" say from 10 to 20
at nomcode X then

FindOldNominal(X) still says 10, unless I go into the cell where the
formula call of '=FindOldNominal(X)' is and press enter again.

My question is I would like it to update it self automatically like the sum
function "=sum" does. Is there a reason why this macro isn't or are all
macros like this.
Is there a way round it if this is the case.


Many thanks in anticipation

James
 
see response in programming

--
HTH

Bob Phillips

(replace xxxx in email address with googlemail if mailing direct)
 
You must log in or register to reply here.

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

My first macro, uses Vlookup but doesnt update unless hit I enter 3
Macro Query - 6
Color contents of a cell accessed by a function? 4
changing the appearance of a cell accessed 1
Add comments via a function - please could you ammend my code/ pseudocode to work 6
Accessing a variable(a range) and modifying it 1
My first macro - doesnt work - function not recognised 2
using excel functions in a macro - my first macro! ? 1

Back
Top