| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
delete last line of numbers
Hi...
I import a block of text from another sheet with a simple macro but want to delete the last line that holds numerical values. The block of data varies in depth and the line to removed can vary say from line 20 - 8000. I need some code that will identify when the numercial data stops and to delete the line on which the data appears last. Anything out there? Cheers Gordon. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete all negative numbers leaving only positive numbers | Excel Discussion (Misc queries) | |||
| 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 all but first line | Excel Discussion (Misc queries) | |||
| Line numbers some numbers are blue some are black | Excel Discussion (Misc queries) | |||
| how to delete to the end of line | Excel Programming | |||
![Gordon[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
