Hi z.entropic

You can find information here to find the last row number of a column
http://www.rondebruin.nl/last.htm

You can create a loop through all your columns and do the things you want

--

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


"z.entropic" wrote in message ...
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