Link to home
Start Free TrialLog in
Avatar of thomas-sherrouse
thomas-sherrouseFlag for United States of America

asked on

Excel VBA Macro to Select a Cell based on it's Cell Number Format

I've got a Spreadsheet that I inherited and it somehow has all the cells with the same Date Format. The majority of the sheet has been updated the the cells are in this format anymore, but when I go to input data into a blank cell or add a column etc... the default cell number format is "[$-409]d-mmm;@" I know there is a way to find and select all the cells that have this format, but I don't know how to do it.

So if someone could help me with a Macro that selects all cells with this format:

[$-409]d-mmm;@

I would appreciate it.

Once I select all of the cells I plan to just format then as "General"

Thanks
ASKER CERTIFIED SOLUTION
Avatar of Ejgil Hedegaard
Ejgil Hedegaard
Flag of Denmark image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial