Worksheetfunction

Hi Friends,

I would need your help in solving the below queries.

Q1. Any formulas code that I write thru macro. For ex, activecell.value=WorksheetFunction.VLookup, WorksheetFunction.sum etc.,. and after the macro is executed. The formulas are not visible in the cell, which means the formulas are not autorefreshed If I have any new values. How do I make it auto refreshed or autocalculate by the excel itself based on the new values.

Q2. When I try the below macro in excel, if the vlookup target is not found the activecell should pick False as the value. but it is not picking. How do I do it?

ActiveCell.Value = WorksheetFunction.VLookup(ActiveCell.Offset(0, -1), Range("Sheet1!B:C"), 2, False)