Thread: VBA Function to Check if value in a String variable is actually a cell Address
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Dana DeLouis Dana DeLouis is offline
external usenet poster
  
Posts: 947
Default VBA Function to Check if value in a String variable is actually a cell Address
..either a valid address ...

Oops! You are right. I missed that point. Sorry.

--
Dana DeLouis


"Rick Rothstein (MVP - VB)" wrote in
message ...
Unless I am missing something, the (shortened) code I just posted will
return TRUE if the passed in String is either a valid address (or address
range) OR a valid Named Range... I don't think a separate test function is
required.

Rick


Reply With QuoteReply With Quote