Solved: VLOOKUP REFRESH

[Nicolaf]

Hi,

Starting from Sheet2 I would like to have a macro that looks for number 1 in column A in Sheet1 and when it has found it goes to columns K,L and M and performs an F2 (from keyboard) function on each of those cells.
Basically it refreshes them.

So if number 1 is found in cell A4 then the F2 function is performed on cells K4, L4 and M4.

How do I do that?

:dunno

Thanks,
Nix

[mdmackillop]

Can you not do this using Calculate? (F9 key)

[Nicolaf]

We use some financial engineering formulas and one day the F9 function has stopped working and no one knows the reason. F2 on individual cells still works so I was trying to see if I could automate this F2 function.

Thanks!
Nix