excel 2003 - VBA - Correct "Number Stored asText" errors

[silentbuddha]

Hi,

I recently finished my vba code to import results from a database table. When the VBA macro imports the data onto the worksheet all my values are stored as text in excel and thus the green arrow error appears.

The funny thing is that excel kept my dates as a date....( column A )

How would I proceed to create a procedure

1 - check my used range for any cell values that have the error : "Number-Stored-as-text"
2 - if the error does exist on that cell, format the cell to a number

Thanks in advance

 

[VoG]

This might work

Sub test()
With ActiveSheet.UsedRange
    .Value = .Value
End With
End Sub

 

[silentbuddha]

Hi Peter ( VoG ),

thanks for the code.....woooooooooo yooooooooooo...it worked perfectly !

*** doing cart-wheels ***