If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Vlookup Cell Format
Can vlookup or any other function bring over the cell formatting?
|
#2
|
|||
|
|||
Vlookup Cell Format
Nope.
Formulas return values. Richard wrote: Can vlookup or any other function bring over the cell formatting? -- Dave Peterson |
#3
|
|||
|
|||
Vlookup Cell Format
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? |
#4
|
|||
|
|||
Vlookup Cell Format
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 |
Thread Tools | |
Display Modes | |
|
|