View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Vineeth Vineeth is offline
external usenet poster
 
Posts: 8
Default Excel the cell exists using cell name

Hi,

thanks for your quick reply

my requirement is i need to get the values from user entered(means user can
choose range)

so i use worksheet.getrange method but if user enter a wrong range value
will give exception


how can avoid this bug
"Gary''s Student" wrote:

All worksheets contain cell A1.
--
Gary''s Student - gsnu200860


"Vineeth" wrote:

Hi,

iam developing a com addin for excel 2007, now i need to check the worksheet
contains cell named "A1"

how can implement this


like this
worksheet.cell.contains("A1")

Thanks