| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup Cell Format
Can vlookup or any other function bring over the cell formatting?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vlookup Cell Format
Nope.
Formulas return values. Richard wrote: Can vlookup or any other function bring over the cell formatting? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup,format general, format text | New Users to Excel | |||
| cell format - remove cell format pattern without effecting colors | Excel Discussion (Misc queries) | |||
| vlookup cell format problems | Excel Worksheet Functions | |||
| format cell based on results of vlookup function | Excel Worksheet Functions | |||
| How do I copy data in single cell format to a merged cell format | Excel Discussion (Misc queries) | |||
Linear Mode
