VBA
10.11.2020 07:40:28
Martien
I`m working on a file where I want to loop through all rows, step by step. I have a file with machine info like brandname, article numbers etc.
The difficulty is that in the row I have to ranges where I have to do something. Due to the fact that e.g. column AH till AL holds data which I want to copy to another workbook and Paste special with Transpose. This is something I know how to do for one row.
After this copy and paste step I want to move one row down to do the same. I can do this now by changing the Row number from Range("AH2:AL2") to next Range("AH3:AL3") manual.
Is there a function where I can loop to another row?
Thanks