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

  • Thread starter Thread starter delisle_d
  • Start date Start date
D

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.......
 
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
 
Back
Top