Skip to main content
Question

Excel Counter/Variable operations

C
Forum|alt.badge.img+1

OK, I know V11 extremely well. I am learning AA2019 360 Community Addition.

2 Silly questions that I can’t seem to wrap my head around:

  1. How the heck do you get the Excel Row Number you are on to use as a counter? I want the row number I am currently on during a loop?
  2. Say i want to increment the counter by +1. In aa V11 there were variable operations to do so, Is there an equivalent in V2019 360? 

C
Forum|alt.badge.img+1
  • Chris 1066
  • Cadet | Tier 2
  • March 18, 2023

All I want to do (which was simple in AAV11) is to log to file ExcelRow[0] and the current row # the loop is on. Here are my commands:

 

C
Forum|alt.badge.img+1
  • Chris 1066
  • Cadet | Tier 2
  • March 18, 2023

This is the result I get:

 

C
Forum|alt.badge.img+1
  • Chris 1066
  • Cadet | Tier 2
  • March 20, 2023

Ok, I figured it out. I had to do the steps manually. But this does work as expected.

 

Reply


Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings