Excel the cell exists using cell name

[Vineeth]

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

 

[Gary''s Student]

All worksheets contain cell A1.

 

[Vineeth]

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

 

[Jacob Skaria]

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

 

[Vineeth]

Hi Jacob ,

thanks for your reply

when when i try to take the the range will fire exception

excelSheet.get_Range(0,0)