How do i select columns A6:to the end of sheet ?
I am trying to do this via activity “for each excel row” below is my current approach which goes through the complete excel
I have also tried using the below but it is not working and its giving me error
what i am trying to achieve?
selecting data from lets say A6:End so that execution time of for loop would be reduced
For Range A6 to End you can use .Range(“A6”) and for Specific Range you can use .Range(“A6:Z10”)
For reference you can see below images for both the condition.
**Z10 is for reference (For selecting specific range)
Hope this helps you.
in for each row data table
you will get the 6 th row in first place
Hi Shiva_Nikhil it is working thank you very much for your help much appreciated!
Hi Nawazish_Ahmad even this is working thank you very much for your help much appreciated!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.