| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
macro to delete the last value in each column
My worksheets have dozens of columns, each with up to a few thousand rows.
Both enumber of columns and rows varies from one data set tp another. I'd like to have a macro that would delete the last value in each column, but only if it's less than 90% of the penultimate value in that column. Obviously, simply recording a macro with a Ctrl-Down key sequence in each column will not work as the the last value is recorded as a static address, but maybe using the OFFSET function would... Help, please... z.entropic |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete a Column when in a Macro-Worksheet Event? | Excel Worksheet Functions | |||
| delete a macro that isn't in macro list | Excel Discussion (Misc queries) | |||
| How can I delete a macro when the Delete button is not active? | Excel Worksheet Functions | |||
| set up a macro to delete characters in each cell of a column | Excel Discussion (Misc queries) | |||
| How do i delete a macro in Excel 2003 when delete isn't highlight | Excel Discussion (Misc queries) | |||
Threaded Mode
