Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a named range, that I would like to search for a name, and then delete
the record (row) in that range that contains the name I found. I can do a Range.Find to find the name, but it returns me a Address of the cell on the spreadsheet. I was wondering how would I find the location of the cell relative to the Range, rather than relative to the worksheet. If I used the Macro Recorder to right click on the cell containing the name, and choose "Delete Table Row", I get the following code: Selection.ListObject.ListRows(61).Delete The problem with that is that the 61, is the row number relative to the named range, and I don't know how to get that programatically. Any help would be appreciated. Thanks, Steve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to Delete blanks between a range and populate only the names inthe given range | Excel Discussion (Misc queries) | |||
How to Delete a Range in Closed Workbook (to Replace Delete Query) | Excel Discussion (Misc queries) | |||
Range.Delete and Range.Resize.Name performance issues | Excel Programming | |||
find and delete duplicate entries in two columns or find and prin. | Excel Programming | |||
find and delete text, find a 10-digit number and put it in a textbox | Excel Programming |