Application.Calculate & VLOOKUP
the code you show pastes values on a sheet. What does that have to do with
Vlookup formulas.
In any event, what you describe would indicate that your formulas are being
seen as text values rather than formulas. when you look at the cell is it
displaying the formula? If not, what does it display?
If you formulas are seen as text and not formulas, you can calculate until
you are blue in the face and they won't be treated as formulas until you
force Excel to reevaluate them. You can do this by selecting the range that
contains the formulas and do
Edit=Replace
What = (equal sign)
With = (equal sign)
This will be like a mass F2 of your worksheet and your formulas should then
work.
--
Regards,
Tom Ogilvy
"BHARATH RAJAMANI" wrote in
message ...
I have several Vlookup functions in my worksheet. They do not compute
until
I F2 into every cell. (Tools Options Calculation is Automatic) Can I use
a
macro function that computes the value of the cell and saves me the pain
of
having to F2 every cell that has the Vlookup formula
TIA!!
My code is as below:
Sub update()
Range("B1").Select
Selection.End(xlDown).Select
ActiveCell.Offset(0, 2).Range("A1").Select
Range(Selection, Selection.End(xlToRight)).Select
Selection.Copy
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone,
SkipBlanks:= _
False, Transpose:=False
Application.CutCopyMode = False
'ActiveWorkbook.Worksheets(1).Calculate
Application.CalculateFull
End Sub
Regards,
--
Manager, International Private Banking, International Banking Group, ICICI
Bank
East Wing 8th floor South, ICICI Towers, Bandra Kurla Complex, Mumbai
India
400051
|