Searching for Excel Cells with [Format|Category|Scientific] Specif

[delisle_d]

I am currently writting a VBScript that needs to search for Cells in Excel
that have been formatted in Scientific. I need to exclude these specific
Cells to obtain output recommended for my project. Can someone help me
understand what should be looked for?

Tying to execute:

If objExcel.Cells(intRow,column).xxxxx = Scientific Then
intRow = intRow + 1

Else.......

 

[Bernie Deitrick]

delisle_d,

If Right(objExcel.Cells(intRow,column).NumberFormat, 4) = "E+00" Then
MsgBox "Scientific"
intRow = intRow + 1
Else
'other code
End If

HTH,
Bernie
MS Excel MVP