HOW DO I COPY THE LAST NON BLANK CELL IN A COLUMN
 

I am trying to create a macro that will copy the last non-blank cell in a
running total column that appears on a number of worksheets to a summary
worksheet in the same workbook. Any suggestions?

HOW DO I COPY THE LAST NON BLANK CELL IN A COLUMN
 

Try Bob Phillips' marvellous coverage at his page at:
http://www.xldynamic.com/source/xld.LastValue.html
(Formula and vba solutions provided)
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Needles" wrote in message
...
I am trying to create a macro that will copy the last non-blank cell in a
running total column that appears on a number of worksheets to a summary
worksheet in the same workbook. Any suggestions?

HOW DO I COPY THE LAST NON BLANK CELL IN A COLUMN
 

macro recorder
in absolute mode
select the range(cell) you want to start
in relative mode
press end and then the down arrow
right click mouse~copy
now in absolute mode select the cell you want to paste, and paste
now select the range you want to be at and stop recording

this may have to be recorded in relative mode and absotlute because if
you only use absolute mode the macro will always stop at the same
cell,when in macro recorder click on the square button, if it appears
depressed, then you are in relative mode

Practice this a few times before you record the macro because it is a
pain to record a macro and then find out you forgot something
Dave