I ended up going with two columns, and got it working with this:
Dim i As Long
Dim iCol As Long
Dim num As Long
iCol = 7
num = 100
Columns(iCol).Select
Range("IV1").Select
Selection.End(xlToLeft).Select
For i = 0 To num
Selection.EntireColumn.Copy
ActiveCell.Offset(0, 2).Select
ActiveSheet.Paste
Next i
Thanks!
Ryan--
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.
"ryguy7272" wrote:
Thanks FSt1! I've seen that before. Forgot about it; thanks for reminding
me. One more thing, how can I start in column B, copy then paste one column
to the right, then copy then paste that column (now in column C) and copy
then paste one to the right (now in column D) and copy then paste one to the
right (now in column E)...etc...
Thanks!
Ryan---
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.
"FSt1" wrote:
hi
i think you may be interested in the ontime method.
in vb help, type ontime. select ontime method
also see this site. lot of how to start and stop timers.
http://www.cpearson.com/excel/OnTime.aspx
Regards
FSt1
"ryguy7272" wrote:
How can I create a macro that calculates a time interval, say 10 seconds, and
then copies all data from column B to column C, then waits 10 minutes, then
copies columns C to D, waits 10 minutes, then copies D to E, and so on and so
forth.
Thanks!
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.