On 03-Mar-17 8:00 PM, Peter T wrote:
"Tim Childs" wrote in message
Hi

In VBA I want to get the cell information on a cell e.g. in the
Application itself, I can put:
=CELL("type",A1)
in Cell B1
However, I would like to extract the same information about (multiple)
cells directly from VBA itself i.e. in a procedure, without entering a
formula into an Excel cell.
Please can you give me the VBA syntax for that.

CELL + "type" doesn't tell you much - the cell contains a string, is
empty, or anything else. Other VBA functions can tell you a lot more but
give some idea of what you're looking for and what you want to do with it.

Peter T


Thanks for response

I want to distinguish between cells that have been output as labels and
those that are values. In the latter, dates are numbers and in the
former, I will use TextToColumns to convert the "date labels" to proper
date values. I hope that clarifies my request, if not, please do say so.

Tim