Logo 
Search:

MS Office Answers

 Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Raju Iyer   on Mar 19 In MS Office Category.

Deleting Test


  
Question Answered By: Adalard Fischer   on Mar 19

VBA has a way to tell the type of data  in a cell. It is TypeName


If TypeName(ActiveSheet.Cells(r, 1).Value) <> "Double" Then
' If non-number, abort
Debug.Print " - - - no frequency - - -"
Else ' Belongs to TypeName
Debug.Print " - frequency present -"
f = ActiveSheet.Cells(r, 1)

Share: 

 

This Question has 2 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Deleting Test Or get search suggestion and latest updates.


Tagged: