| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding the Format of a Cell
Have a large dynamically populated worksheet (from another application).
Some cells are date formats, currency, text, etc. I need allof the cells to be formatted as text without losing their 'look and feel'. I can't use =Cell("Format",A1) in VBA and can't find any equivalent. On dates I could say the equivalent of - If '=Cell("Format",A1)' = "D4" Then Format(Activecell.Value,"m/d/yy") Any Ideas? TIA- -- Gus Evans |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Finding the Format of a Cell
if you use a Variant variable (which I guess you must), you can use the
TypeName property (see VBA help) "GusEvans" wrote: Have a large dynamically populated worksheet (from another application). Some cells are date formats, currency, text, etc. I need allof the cells to be formatted as text without losing their 'look and feel'. I can't use =Cell("Format",A1) in VBA and can't find any equivalent. On dates I could say the equivalent of - If '=Cell("Format",A1)' = "D4" Then Format(Activecell.Value,"m/d/yy") Any Ideas? TIA- -- Gus Evans |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Finding the Format of a Cell
Thanks - worked like a charm.
-- Gus Evans "Martin" wrote: if you use a Variant variable (which I guess you must), you can use the TypeName property (see VBA help) "GusEvans" wrote: Have a large dynamically populated worksheet (from another application). Some cells are date formats, currency, text, etc. I need allof the cells to be formatted as text without losing their 'look and feel'. I can't use =Cell("Format",A1) in VBA and can't find any equivalent. On dates I could say the equivalent of - If '=Cell("Format",A1)' = "D4" Then Format(Activecell.Value,"m/d/yy") Any Ideas? TIA- -- Gus Evans |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cell format - remove cell format pattern without effecting colors | Excel Discussion (Misc queries) | |||
| * causing problems with finding duplicates with conditional format | Excel Discussion (Misc queries) | |||
| finding last non-blank cell and then copying it to the next cell | Excel Discussion (Misc queries) | |||
| How do I copy data in single cell format to a merged cell format | Excel Discussion (Misc queries) | |||
| Finding Cell Interior Colour of First Cell in Column | Excel Programming | |||
Hybrid Mode
