Need continuously running macro when conditions are met

C

Cynthia

Hope someone can help. I have 2 spreadsheets. In SS1 I'm pulling data from columns B, C, onward and pasting it into rows 1, 2, etc in SS2. Of course I can easily record a macro by performing this function 1 cell at a time, but these will eventually be very large spreadsheets, maybe 700 columns in SS1 being pasted into 700 rows in SS2. How do I write the macro to perform this function for one column and tell it to continue running as long as the next column has data
 
T

Tom Ogilvy

there are only 256 columns in Excel, so you might want to rethink you
approach.

Just select all the columns and paste trasposes

Sub Tester3()
Worksheets("SS1").Rows(1).Copy
Worksheets("SS2").Range("A1").PasteSpecial Transpose:=True

End Sub

There is not reason not to do it all in one step using the whole row.

--
Regards,
Tom Ogilvy




Cynthia said:
Hope someone can help. I have 2 spreadsheets. In SS1 I'm pulling data
from columns B, C, onward and pasting it into rows 1, 2, etc in SS2. Of
course I can easily record a macro by performing this function 1 cell at a
time, but these will eventually be very large spreadsheets, maybe 700
columns in SS1 being pasted into 700 rows in SS2. How do I write the macro
to perform this function for one column and tell it to continue running as
long as the next column has data?
 

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

Top