Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Detect Prcentage Format in a Cell
Hi,
I want to be able to detect the format of a formula or value in a cell and particularly if it has percentage format. I can't find a clever VBA statement to detect the cell format so I thought about testing the cell value using "Instr" to see if the "%" was the last character in the string. However when I write a VBA statement to test the variable it restates the value of the cell from %'s to a decimal (e.g. 5% becomes 0.05) thus eliminating the % sign I'm attempting to detect... Ideas most welcome...Chris |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Detect Cell Colour | Charts and Charting in Excel | |||
Date Auto-detect & format Issues | Excel Discussion (Misc queries) | |||
prcentage of hours | Excel Discussion (Misc queries) | |||
How to detect if a cell is formula | Excel Programming | |||
Detect if conditional format is true | Excel Programming |