PDA

View Full Version : looking up text and cell fomat?



ironj32
02-25-2009, 07:11 AM
i'm wondering if it is possible to look-up the contents of other cells, including the cell format? using VLOOKUP will get the Text, but I'd like to be able to have the exact same cell formatting (text, font color, background color, bold, strikethrough, etc...). i'm assuming this could be done with VBA and i've been digging around but haven't found anything yet (my vba skills aren't that great).

any help would be greatly appreciated!

nst1107
02-25-2009, 09:09 AM
Check out Graham Paramore's add-in. http://www.vbaexpress.com/forum/showthread.php?t=5075