copy paste flexible with vba

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

Guest

Another issue as well... I want to create a button that automatically copy an
area from 5 different sheets and put them into a new sheet. Not that complex,
but the problem is that the number of rows included when copying might differ
from time to time so I cannot just create a macro to paste in the second area
below the first one as I do not know how many rows the first one will have
next time. Anyone know the VBA to do this?

Thanks
 
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

Copy/Paste and remove blanks VBA 0
Copy columns and paste with blank column between 5
Pasting into an active cell 3
Don't want to hard-code file name in macro 3
copy/paste in the next column 4
loop to copy paste 5
Find matches in different spreasheets then copy and paste to new s 15
copy and paste data from different sheets 1

Back
Top