<div>
You could use TypeName(Activecell.value)<wbr /><br />
<br />
Regards,<br />
Rory
</div>


You could use TypeName(Activecell.value)

Regards,
Rory

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
I am writing an Excel VBA app wich does certain things based on the type of<br />
content in a cell.<br />
What is the best way to see if a cell contains text, numbers, dates etc
</div>
</div>


Hi

I am writing an Excel VBA app wich does certain things based on the type of
content in a cell.
What is the best way to see if a cell contains text, numbers, dates etc

Excel VBA cell data types

Windows 2000 is an operating system for use on both client and server computers. It is the successor to Windows NT 4.0, and is the last version of Microsoft Windows to display the "Windows NT" designation. Four editions of Windows 2000 were released (Professional, Server, Advanced Server, and Datacenter Server) that shared a core set of features, including many system utilities such as the Microsoft Management Console. All versions of the operating system support NTFS 3.0, Encrypting File System, as well as basic and dynamic disk storage. The Windows 2000 Server family includes support for Active Directory services, Distributed File System and fault-redundant storage volumes.

Windows 2000

This topic area includes legacy versions of Windows prior to Windows 2000: Windows 3/3.1, Windows 95 and Windows 98, plus any other Windows-related versions including Windows Mobile.

Windows OS

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.