How do you make "Add-In's"?
See
http://www.jkp-ads.com/Articles/DistributeMacro00.htm


One thing, when using the filter and delete row, it only filters the row, it
does not delete it. Is that correct?
Must see the workbook


One last question for the day, I need to go to the last cell in column C
with data, go down one cell, select that row and all the rows below and
delete them.

Try this one

Sub test()
Dim LastRow As Long
With ActiveSheet
LastRow = .Cells(.Rows.Count, "C").End(xlUp).Row
.Rows(LastRow + 1 & ":" & .Rows.Count).Delete
End With
End Sub


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"pgarcia" wrote in message ...
Nice!!!
How do you make "Add-In's"?

One thing, when using the filter and delete row, it only filters the row, it
does not delete it. Is that correct?

One last question for the day, I need to go to the last cell in column C
with data, go down one cell, select that row and all the rows below and
delete them.

Thanks and thank for the Add-In


"Ron de Bruin" wrote:

Hi pgarcia

You can use EasyFilter
http://www.rondebruin.nl/easyfilter.htm

If you want code you must use AdvancedFilter


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"pgarcia" wrote in message ...
Hello all,
1. I need to filter the follow: GDL, MTY, QRO and SLW from a sheet.
2. Copy only the filtered data to clipboard (columns A-H).
3. Delete the rows with the filtered data from that sheet.
Then
1. Open new sheet
2. Paste data to that sheet.
3. Delete rows (in column C) that have no data.

Thanks (the Naives) Office 2000