| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
delete last-line help.
I have a code that will delete the last line of a spreadsheet -
Range("a65536").End(xlUp).Select Selection.EntireRow.Delete What I'd like it to do is look into that line, and if the value for the cell in column A is MTD_AVG to delete the line, but if it is anything else to leave the line intact. Help please? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Challenge - Excel Line Feed Character CHR(10) - How to Delete and keep the text formatting without going ro single line in a cell ? | Excel Programming | |||
| Challenge - Excel Line Feed Character CHR(10) - How to Delete and keep the text formatting without going ro single line in a cell ? | Excel Worksheet Functions | |||
| Delete first line line(s) of text-file? | Excel Programming | |||
| Delete every other line | Excel Programming | |||
| how to delete to the end of line | Excel Programming | |||
Threaded Mode
