Yep.

But knowing when to run the macro may be difficult to determine.

If you only cared about the cell that is used as the lookup value changed, then
you may be able to use the worksheet_change event (if the user typed in the new
value).

But if the table were reformatted, then this event would not fire.



"Mr. Haney" wrote:

On Fri, 17 Apr 2009 12:28:42 -0500, Dave Peterson
wrote:

Nope.

Formulas return values.

Richard wrote:

Can vlookup or any other function bring over the cell formatting?

Can a macro copy and paste or otherwise "grab" a cell's formatting for
use in another cell or sheet?

--

Dave Peterson