Hi, I'm having a lot of trouble with this as well. I have studied the examples and read the many posts for days now, to no avail. I understand part of it.....maybe, but I'm hoping for a little more help from you guys. Hope I'm not Hijacking thread, it is along the same lines.
I have an Excel Workbook named Book1
Starting in Column A Row #1
Just to keep it similar, I have:
Red
White
Blue
I would like to copy each of these and go over one column and paste each these. Using copying and pasting both using increasing variables, both starting a %T1%.
Could you guys help me with this? Here is what I have so far. It does not work correctly yet! I can't quite figure out how to set what is on the clipboard to %TN1%. Also, I don't have the paste in yet because the top part is wrong.