Identifying Cell contents in Excel vba - Text, Date, Value etc

[xplo5iv]

Hi

I have created a macro for use in financial spreadsheets. The macro takes the formulae for each cell in a range and converts it to one rounded to 2dp

e.g. Original Formula "=A6/3" , New formula "=Round(A6/3,2)"

I've used an IF with .HasFormula to make sure it doesn't muck up any text, or already include "Round" in the formula, and all works well.

BUT I'd like to be able to get it to round any numerical values too, without messing up dates or text. (This would be particularly useful if Paste Special...Values is used)

Is their a way of identify the cells correctly in vba?

Thx in Advance

Jonathan

 

[xlbo]

errrrrrmmmm

IsNumeric
IsDate

.......

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[xplo5iv]

Thanks Geoff

New it must exist somehow, but I was looking in the Excel library, rather than wider vba.

Doh!

 

[arides]

some addendum,

if you want to check if the number is an integer (for example) u should FIRST check if it's numeric

if isnumeric() then
if isinteger() then