I need to extract an activecells format and apply that format to a
variable.
I am using the activecell value and placing it alongside a checkbox as
its text. At a later date I am extracting this text value as a search
parameter. Unfortunately it looses format profile and I can't search
on dates or currency.
If I had the format stored I could condition the variable prior to
using it in a search..... any help appreciated.