View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andreas Andreas is offline
external usenet poster
 
Posts: 20
Default copy paste flexible with vba

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