View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] mcolson1590@gmail.com is offline
external usenet poster
 
Posts: 1
Default Check if a named range exists with VBA?

I am trying to see if a named range exists with VBA. In my
subroutine, I browse for and then open another Excel file. I then set
ranges on that sheet = to defined variables. I would like to verify
that these ranges exist on that sheet before trying to set them (in
order to avoid an error in running). For example, does that sheet
have a named range "Name"?

Thanks for any help,

Matt