Selection.Formula = "=VLOOKUP(A1, $B$1:$C$1000, 2, FALSE)"

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"NetWave128" wrote in message
...

I have a userform that has a selection method... I would like to fill a
range of cells with a different formula depending on which cmd button
is pressed in the form.

The Formula is a lookup and it is the same it just refers to different
sheets based on the user input...

Thank You-


--
NetWave128
------------------------------------------------------------------------
NetWave128's Profile:
http://www.excelforum.com/member.php...fo&userid=2297
View this thread: http://www.excelforum.com/showthread...hreadid=274089