Copy value to last available cell

  • Thread starter Thread starter Ed
  • Start date Start date
E

Ed

How would i copy a value to the next avaliable cell in
sheet(Error handle)and then loop and copy that value to
the next cell underneath that one.
 
Ed
I don't think you want what you said you want. You said that you want
some value copied to the next available cell and then copy the same value to
the cell below that cell. You would end up with 2 cells with the same
value. Is that what you want? If so, you need a statement like:
Range("A" & Rows.Count).End(xlUp)(2).Range("A1:A2").PasteSpecial
There is no looping involved to do this. It's just a simple Copy/Paste
procedure.
Post back if this is not what you wanted and give more detail of what
you have and what you want to do. HTH Otto
 
Back
Top