View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
debartsa debartsa is offline
external usenet poster
 
Posts: 18
Default Checking to see if a Range Object exists?

Hi Everybody,

I'm using Excel 97 with VBA... Is there a way to programmatically check if a
named Range exists

i.e. I want to access === ActiveSheet.Range("Activity") <==== only
if it exists. The problem is it'll crash referencing this if it doesn't
exit?

Thanks for any help!
Sam