Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete Rows containing pop-up entry
Thanks much Ron..........unfortunately I have to work with Excel97 here.
But, I've downloaded your Add-in and will put it to good use at home. Thanks again, Vaya con Dios, Chuck, CABGx3 "Ron de Bruin" wrote: For a Add-in solution see http://www.rondebruin.nl/easyfilter.htm -- Regards Ron de Bruin http://www.rondebruin.nl "CLR" wrote in message ... Thanks ever so much Guys....Paul B, Jason, and JE.......all three worked fine-fine-superfine. I think I will go with Jason's tho, because it seems to work with either numbers or case-senitive text. Thanks again for the rapid and working responses......any one of which would have served me, but it's always nice having a choice. Vaya con Dios, Chuck, CABGx3 "CLR" wrote: Hi All...... I got this from a search of this group, and it works fine. Hi Lawlerd, this code was posted by Frank Kabel, it should do what you you need, it will delete every row with the word 'total' in column A... Sub delete_rows() Dim RowNdx As Long Dim LastRow As Long LastRow = ActiveSheet.Cells(Rows.Count, "A").End(xlUp).row For RowNdx = LastRow To 1 Step -1 If Cells(RowNdx, "A").Value = "total" Then Rows(RowNdx).Delete End If Next RowNdx End Sub My question is, can it be modified to give me a pop-up requesting a value to search for and delete the rows containing it, instead of a hard-coded "total"? Many TIA's Vaya con Dios, Chuck, CABGx3 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete Rows containing pop-up entry
Hi
unfortunately I have to work with Excel97 After I have finish the new version with a Date tab for filtering on months ,Year, week numbers, weekdays, ................ I will see if I can fix the problems in Excel 97. -- Regards Ron de Bruin http://www.rondebruin.nl "CLR" wrote in message ... Thanks much Ron..........unfortunately I have to work with Excel97 here. But, I've downloaded your Add-in and will put it to good use at home. Thanks again, Vaya con Dios, Chuck, CABGx3 "Ron de Bruin" wrote: For a Add-in solution see http://www.rondebruin.nl/easyfilter.htm -- Regards Ron de Bruin http://www.rondebruin.nl "CLR" wrote in message ... Thanks ever so much Guys....Paul B, Jason, and JE.......all three worked fine-fine-superfine. I think I will go with Jason's tho, because it seems to work with either numbers or case-senitive text. Thanks again for the rapid and working responses......any one of which would have served me, but it's always nice having a choice. Vaya con Dios, Chuck, CABGx3 "CLR" wrote: Hi All...... I got this from a search of this group, and it works fine. Hi Lawlerd, this code was posted by Frank Kabel, it should do what you you need, it will delete every row with the word 'total' in column A... Sub delete_rows() Dim RowNdx As Long Dim LastRow As Long LastRow = ActiveSheet.Cells(Rows.Count, "A").End(xlUp).row For RowNdx = LastRow To 1 Step -1 If Cells(RowNdx, "A").Value = "total" Then Rows(RowNdx).Delete End If Next RowNdx End Sub My question is, can it be modified to give me a pop-up requesting a value to search for and delete the rows containing it, instead of a hard-coded "total"? Many TIA's Vaya con Dios, Chuck, CABGx3 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete Rows containing pop-up entry
cool........thanks
Vaya con Dios, Chuck, CABGx3 "Ron de Bruin" wrote: Hi unfortunately I have to work with Excel97 After I have finish the new version with a Date tab for filtering on months ,Year, week numbers, weekdays, ................ I will see if I can fix the problems in Excel 97. -- Regards Ron de Bruin http://www.rondebruin.nl "CLR" wrote in message ... Thanks much Ron..........unfortunately I have to work with Excel97 here. But, I've downloaded your Add-in and will put it to good use at home. Thanks again, Vaya con Dios, Chuck, CABGx3 "Ron de Bruin" wrote: For a Add-in solution see http://www.rondebruin.nl/easyfilter.htm -- Regards Ron de Bruin http://www.rondebruin.nl "CLR" wrote in message ... Thanks ever so much Guys....Paul B, Jason, and JE.......all three worked fine-fine-superfine. I think I will go with Jason's tho, because it seems to work with either numbers or case-senitive text. Thanks again for the rapid and working responses......any one of which would have served me, but it's always nice having a choice. Vaya con Dios, Chuck, CABGx3 "CLR" wrote: Hi All...... I got this from a search of this group, and it works fine. Hi Lawlerd, this code was posted by Frank Kabel, it should do what you you need, it will delete every row with the word 'total' in column A... Sub delete_rows() Dim RowNdx As Long Dim LastRow As Long LastRow = ActiveSheet.Cells(Rows.Count, "A").End(xlUp).row For RowNdx = LastRow To 1 Step -1 If Cells(RowNdx, "A").Value = "total" Then Rows(RowNdx).Delete End If Next RowNdx End Sub My question is, can it be modified to give me a pop-up requesting a value to search for and delete the rows containing it, instead of a hard-coded "total"? Many TIA's Vaya con Dios, Chuck, CABGx3 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete Rows containing pop-up entry
I will see if I can fix the problems in Excel 97.
That would be great Ron, but most users would probably be happy if you could just get your Addin to work with Excel 97 with its current problems. <G -- Regards, Tom Ogilvy "Ron de Bruin" wrote in message ... Hi unfortunately I have to work with Excel97 After I have finish the new version with a Date tab for filtering on months ,Year, week numbers, weekdays, ................ I will see if I can fix the problems in Excel 97. -- Regards Ron de Bruin http://www.rondebruin.nl "CLR" wrote in message ... Thanks much Ron..........unfortunately I have to work with Excel97 here. But, I've downloaded your Add-in and will put it to good use at home. Thanks again, Vaya con Dios, Chuck, CABGx3 "Ron de Bruin" wrote: For a Add-in solution see http://www.rondebruin.nl/easyfilter.htm -- Regards Ron de Bruin http://www.rondebruin.nl "CLR" wrote in message ... Thanks ever so much Guys....Paul B, Jason, and JE.......all three worked fine-fine-superfine. I think I will go with Jason's tho, because it seems to work with either numbers or case-senitive text. Thanks again for the rapid and working responses......any one of which would have served me, but it's always nice having a choice. Vaya con Dios, Chuck, CABGx3 "CLR" wrote: Hi All...... I got this from a search of this group, and it works fine. Hi Lawlerd, this code was posted by Frank Kabel, it should do what you you need, it will delete every row with the word 'total' in column A... Sub delete_rows() Dim RowNdx As Long Dim LastRow As Long LastRow = ActiveSheet.Cells(Rows.Count, "A").End(xlUp).row For RowNdx = LastRow To 1 Step -1 If Cells(RowNdx, "A").Value = "total" Then Rows(RowNdx).Delete End If Next RowNdx End Sub My question is, can it be modified to give me a pop-up requesting a value to search for and delete the rows containing it, instead of a hard-coded "total"? Many TIA's Vaya con Dios, Chuck, CABGx3 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete Rows containing pop-up entry
Hi Tom
I hope to have the Beta 2.0 version ready this week with the Date tab. After that I will try to fix the 97 problem. Maybe i need some help from a Excel 97 expert named Tom<vbg -- Regards Ron de Bruin http://www.rondebruin.nl "Tom Ogilvy" wrote in message ... I will see if I can fix the problems in Excel 97. That would be great Ron, but most users would probably be happy if you could just get your Addin to work with Excel 97 with its current problems. <G -- Regards, Tom Ogilvy "Ron de Bruin" wrote in message ... Hi unfortunately I have to work with Excel97 After I have finish the new version with a Date tab for filtering on months ,Year, week numbers, weekdays, ................ I will see if I can fix the problems in Excel 97. -- Regards Ron de Bruin http://www.rondebruin.nl "CLR" wrote in message ... Thanks much Ron..........unfortunately I have to work with Excel97 here. But, I've downloaded your Add-in and will put it to good use at home. Thanks again, Vaya con Dios, Chuck, CABGx3 "Ron de Bruin" wrote: For a Add-in solution see http://www.rondebruin.nl/easyfilter.htm -- Regards Ron de Bruin http://www.rondebruin.nl "CLR" wrote in message ... Thanks ever so much Guys....Paul B, Jason, and JE.......all three worked fine-fine-superfine. I think I will go with Jason's tho, because it seems to work with either numbers or case-senitive text. Thanks again for the rapid and working responses......any one of which would have served me, but it's always nice having a choice. Vaya con Dios, Chuck, CABGx3 "CLR" wrote: Hi All...... I got this from a search of this group, and it works fine. Hi Lawlerd, this code was posted by Frank Kabel, it should do what you you need, it will delete every row with the word 'total' in column A... Sub delete_rows() Dim RowNdx As Long Dim LastRow As Long LastRow = ActiveSheet.Cells(Rows.Count, "A").End(xlUp).row For RowNdx = LastRow To 1 Step -1 If Cells(RowNdx, "A").Value = "total" Then Rows(RowNdx).Delete End If Next RowNdx End Sub My question is, can it be modified to give me a pop-up requesting a value to search for and delete the rows containing it, instead of a hard-coded "total"? Many TIA's Vaya con Dios, Chuck, CABGx3 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete Rows containing pop-up entry
I might be able to lend a hand.
-- Regards, Tom Ogilvy "Ron de Bruin" wrote in message ... Hi Tom I hope to have the Beta 2.0 version ready this week with the Date tab. After that I will try to fix the 97 problem. Maybe i need some help from a Excel 97 expert named Tom<vbg -- Regards Ron de Bruin http://www.rondebruin.nl "Tom Ogilvy" wrote in message ... I will see if I can fix the problems in Excel 97. That would be great Ron, but most users would probably be happy if you could just get your Addin to work with Excel 97 with its current problems. <G -- Regards, Tom Ogilvy "Ron de Bruin" wrote in message ... Hi unfortunately I have to work with Excel97 After I have finish the new version with a Date tab for filtering on months ,Year, week numbers, weekdays, ................ I will see if I can fix the problems in Excel 97. -- Regards Ron de Bruin http://www.rondebruin.nl "CLR" wrote in message ... Thanks much Ron..........unfortunately I have to work with Excel97 here. But, I've downloaded your Add-in and will put it to good use at home. Thanks again, Vaya con Dios, Chuck, CABGx3 "Ron de Bruin" wrote: For a Add-in solution see http://www.rondebruin.nl/easyfilter.htm -- Regards Ron de Bruin http://www.rondebruin.nl "CLR" wrote in message ... Thanks ever so much Guys....Paul B, Jason, and JE.......all three worked fine-fine-superfine. I think I will go with Jason's tho, because it seems to work with either numbers or case-senitive text. Thanks again for the rapid and working responses......any one of which would have served me, but it's always nice having a choice. Vaya con Dios, Chuck, CABGx3 "CLR" wrote: Hi All...... I got this from a search of this group, and it works fine. Hi Lawlerd, this code was posted by Frank Kabel, it should do what you you need, it will delete every row with the word 'total' in column A... Sub delete_rows() Dim RowNdx As Long Dim LastRow As Long LastRow = ActiveSheet.Cells(Rows.Count, "A").End(xlUp).row For RowNdx = LastRow To 1 Step -1 If Cells(RowNdx, "A").Value = "total" Then Rows(RowNdx).Delete End If Next RowNdx End Sub My question is, can it be modified to give me a pop-up requesting a value to search for and delete the rows containing it, instead of a hard-coded "total"? Many TIA's Vaya con Dios, Chuck, CABGx3 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete Rows containing pop-up entry
Thanks Tom
-- Regards Ron de Bruin http://www.rondebruin.nl "Tom Ogilvy" wrote in message ... I might be able to lend a hand. -- Regards, Tom Ogilvy "Ron de Bruin" wrote in message ... Hi Tom I hope to have the Beta 2.0 version ready this week with the Date tab. After that I will try to fix the 97 problem. Maybe i need some help from a Excel 97 expert named Tom<vbg -- Regards Ron de Bruin http://www.rondebruin.nl "Tom Ogilvy" wrote in message ... I will see if I can fix the problems in Excel 97. That would be great Ron, but most users would probably be happy if you could just get your Addin to work with Excel 97 with its current problems. <G -- Regards, Tom Ogilvy "Ron de Bruin" wrote in message ... Hi unfortunately I have to work with Excel97 After I have finish the new version with a Date tab for filtering on months ,Year, week numbers, weekdays, ................ I will see if I can fix the problems in Excel 97. -- Regards Ron de Bruin http://www.rondebruin.nl "CLR" wrote in message ... Thanks much Ron..........unfortunately I have to work with Excel97 here. But, I've downloaded your Add-in and will put it to good use at home. Thanks again, Vaya con Dios, Chuck, CABGx3 "Ron de Bruin" wrote: For a Add-in solution see http://www.rondebruin.nl/easyfilter.htm -- Regards Ron de Bruin http://www.rondebruin.nl "CLR" wrote in message ... Thanks ever so much Guys....Paul B, Jason, and JE.......all three worked fine-fine-superfine. I think I will go with Jason's tho, because it seems to work with either numbers or case-senitive text. Thanks again for the rapid and working responses......any one of which would have served me, but it's always nice having a choice. Vaya con Dios, Chuck, CABGx3 "CLR" wrote: Hi All...... I got this from a search of this group, and it works fine. Hi Lawlerd, this code was posted by Frank Kabel, it should do what you you need, it will delete every row with the word 'total' in column A... Sub delete_rows() Dim RowNdx As Long Dim LastRow As Long LastRow = ActiveSheet.Cells(Rows.Count, "A").End(xlUp).row For RowNdx = LastRow To 1 Step -1 If Cells(RowNdx, "A").Value = "total" Then Rows(RowNdx).Delete End If Next RowNdx End Sub My question is, can it be modified to give me a pop-up requesting a value to search for and delete the rows containing it, instead of a hard-coded "total"? Many TIA's Vaya con Dios, Chuck, CABGx3 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Autocomplete entry - Delete - How? | New Users to Excel | |||
How to delete an repeatitive entry from a worksheet | Excel Worksheet Functions | |||
How to delete rows when List toolbar's "delete" isnt highlighted? | Excel Worksheet Functions | |||
Delete every 3rd row, then delete rows 2-7, move info f/every 2nd row up one to the end and delete the row below | Excel Programming | |||
delete dublicate entry. | Excel Programming |