Greetings!
This one probably can be very simple to some of you, but I'm needing some direction. I'm trying to automatize a very very manual routine, with dozens of steps.
I want to code the logic based on the selected rows by the user. For example, when the user select the rows 1 and 3:
A B C D E 21200 Company A 20.07.2014 100,00 Completed 21201 Company B 20.07.2014 200,00 Error 21202 Company C 21.07.2014 300,00 Pending
I need to perform some actions based on the content of the column "E" to each row selected.
I thought about...
"For Each", but with this command, all the cells in the selected rows would be considered.
"For Variable = 1 to X". Perhaps is better using the "Selection.Rows.Count" as value for "X", but how to reference at the same time, the addresses of the rows and/or cells that's being processed?
Thanks for reading!
Sincerely,
Douglas Marcel