Macro

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

Guest

I have created a macro where I copy a selected row in one sheet and paste the
row in an other sheet. My problem is to paste the rows below each other and
not in the same row over again. Is there a command who tells [range("A2" or
next empty below)] or something similar?
If anyone understands my confusing question and has an answer for this I
would be very greatful.
 
hi,
After the select sheet command add this
from the top...
range("a1").end(xldown).offsest(1,0)
but you have to have a solid column of data in column A
and more that 1 row of data. otherwide you will get an
error
or from the bottom
Range(A65000).end(xlup).offset(1,0)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro problem 2
Copying data to the next blank row 0
Macro to list report results 3
Macro to insert pictures in comments 8
Help on Macro to hide empty rows 4
macro - copy/add to another sheet 1
copy rows from one Data sheet to another sheet based on cell conte 2
Question on Macros 2

Back
Top