Hi Vineeth

You can modify the below function written for VBA and use...myRange should
be declared as a Range object.

Function IsValidRange(strAddress As String) As Boolean
On Error Resume Next
Dim myRange As Range
Set myRange = Range(strAddress)
If Not myRange Is Nothing Then IsValidRange = True
End Function

If this post helps click Yes
---------------
Jacob Skaria


"Vineeth" wrote:

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