| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel the cell exists using cell name
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel the cell exists using cell name
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel the cell exists using cell name
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel the cell exists using cell name
Hi Jacob ,
thanks for your reply when when i try to take the the range will fire exception excelSheet.get_Range(0,0) "Jacob Skaria" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Only allow cell content if it lready exists | Excel Discussion (Misc queries) | |||
| Block cell if specific condition exists | Excel Discussion (Misc queries) | |||
| How do I show that a drop down list exists in a cell? | Excel Discussion (Misc queries) | |||
| Check if text exists within a cell range and return logical vaule - possible? | Excel Discussion (Misc queries) | |||
| Return adjacent cell if conditional formatting exists. | Excel Worksheet Functions | |||
Linear Mode
