Hello, Quite New to VB. My probl

[hankm3]

Hello,

Quite New to VB. My problemis that I can't seem to use the Worksheet Functions (IE: IsText() ).

My problem probably lies between the Keyboard and the Chair.

Any ideas ??

Hank

 

[AndyWatt]

It would help us if we had some code to work with. Can you post any?

Andy
"Logic is invincible because in order to combat logic it is necessary to use logic." -- Pierre Boutroux
"A computer program does what you tell it to do, not what you want it to do." -- Greer's Third Law

 

[hankm3]

Andy,

Figured out answer 3 minutes after posting this Thread.

If isText(Data) then
MsgBox(Data)
End if

Fix:

Application.isText(Data)

Thanks

Hank

 

[AndyWatt]

Glad you could sort it out.

Andy
"Logic is invincible because in order to combat logic it is necessary to use logic." -- Pierre Boutroux
"A computer program does what you tell it to do, not what you want it to do." -- Greer's Third Law