Solved

Excel Loop Counter Number to String question

  • 3 October 2023
  • 4 replies
  • 60 views

Badge +1

Hello,

I am very new to AA, I am able to copy data from one Excel workbook to another successfully (yeyy!), but my paste cell location is giving me issues.  I want it to go to cell A5 and tried using A5 but it puts it in Cell A51, I did A1 to see where it goes and it pastes in A11 so it is adding an extra 10 rows and I am not sure why?  My counter is set to 1.

 

My loop:

 

icon

Best answer by Zaid Chougle 4 October 2023, 05:50

View original

4 replies

Badge +1

I figured it out, I put my Counter variable at 5 and changed A1 to just A.  

Userlevel 4
Badge +14

 

I figured it out, I put my Counter variable at 5 and changed A1 to just A.  

Yes, just have to pass the Column name, not the address. 

 
Badge +1

Thank you Zaid, appreciate the follow up.

Userlevel 4
Badge +14

Thank you Zaid, appreciate the follow up.

Please mark the answer so that the question closes.

 

Reply