how can i copy and paste the value at the bottom of a column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how can i copy and paste the value at the bottom of a column even when the
coloum gets longer
 
The Question as well as your name is ambiguous
don't know if you are ready to copy or to paste.
Sometimes giving the purpose will get you a completely
different and more useful reply.
(who, when, why, where, how, how much)

This macro will get you to the last cell in a column (toolbars.htm)

Sub GotoBottomOfCurrentColumn()
'Tom Ogilvy 2000-06-26
Cells(Rows.Count, ActiveCell.Column).End(xlUp).Select
End Sub

I guess this is the closest I can provide to your question,
it copies the last cell in the column to the cell below it,
using copy & paste.

Sub mavman01()
Cells(Rows.Count, ActiveCell.Column).End(xlUp).Select
Selection.Copy
activecell.offset(1,0).select
ActiveSheet.Paste
end sub

If not familiar with installing and using macros see
http://www.mvps.org/dmcritchie/excel/getstarted.htm

The first macro can be found on my Toolbars page
along with toolbar buttons you can use to invoke.
http://www.mvps.org/dmcritchie/excel/toolbars.htm#macros
 
Need more detail and a better description of what you want to do and what is
not happening for you.

Gord Dibben Excel MVP
 
I'm assuming you are referring to a Total at the bottom of a column, and youa re
looking to copy and paste it elsewhere, in which case why does your Total have
to be at the bottom. If you put it at the top, and refer to the entire range
below it then it will never change position and you will always be able to refer
to it easily. That having been said, it is also not hard to return the last
used cell in your column, but as the others have said if you care to elaborate
on what you have and what you are doing then we can probably provide more help.
 
Back
Top