Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Application.Calculate & VLOOKUP | Excel Programming | |||
"Application.Calculate" does not always update/recalculate the for | Excel Programming | |||
Application.vlookup problem | Excel Programming | |||
application.worksheetfunction.vlookup | Excel Programming | |||
Application Worksheet Function Vlookup error | Excel Programming |