D_Marcel
07-24-2014, 07:12 PM
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
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