View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
B[_6_] B[_6_] is offline
external usenet poster
 
Posts: 2
Default VBA - checking for existance of a property

Hi All,

I'm making a function that works with the Range.Comment object.

There's Comment.Text, but if there's nothing in it, it just errors
out.

How to check if .Text exists or not before attempting to read from it?

Thanks