| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
find and delete
How would i find the last row of information inputted from a form and delete
that row? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
find and delete
Try:
Dim LastRowOnSheet As Long LastRowOnSheet = Sheets("Sheet1").UsedRange.Rows.Count + Sheets("Sheet1").UsedRange.Row - 1 Sheets("Sheet1").Cells(LastRowOnSheet, 1).EntireRow.Delete "enyaw" wrote: How would i find the last row of information inputted from a form and delete that row? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
find and delete
How do i get this to ignore the first row?
"Charlie" wrote: Try: Dim LastRowOnSheet As Long LastRowOnSheet = Sheets("Sheet1").UsedRange.Rows.Count + Sheets("Sheet1").UsedRange.Row - 1 Sheets("Sheet1").Cells(LastRowOnSheet, 1).EntireRow.Delete "enyaw" wrote: How would i find the last row of information inputted from a form and delete that row? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find and delete! | Excel Discussion (Misc queries) | |||
| find row and delete | Excel Discussion (Misc queries) | |||
| 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 | |||
| Find and delete | Excel Programming | |||
Hybrid Mode
