Hello,
The Function I need (I need this as a function not a Sub, as I would like to run it using an If statement) is as the following example:
A1 = 33 ; B1 = 5 ; C1 = 10 ; D1 = 7 E1 = 22
The function will get the entire range's values and will initiate them as the following:
A1 will remain the same - NO need to initiate it at all!
B1 = A1 (33)
C1 = B1 (5)
D1 = C1 (10)
E1 = D1 (7)
This is just an example to illustrate the point, but here are some important rules/facts needed to take on account:
1. The function will need to get different number of cells (in this example the input is only 5 cells but sometimes it will be 10 cells, sometimes 2, sometimes 100..etc,..)
2. The Cells are NOT located at the same location not located at the same order. Meaning, It could be T125, U125, V125 and also can be F33, I39, K108, M59.
The Function I need (I need this as a function not a Sub, as I would like to run it using an If statement) is as the following example:
A1 = 33 ; B1 = 5 ; C1 = 10 ; D1 = 7 E1 = 22
The function will get the entire range's values and will initiate them as the following:
A1 will remain the same - NO need to initiate it at all!
B1 = A1 (33)
C1 = B1 (5)
D1 = C1 (10)
E1 = D1 (7)
This is just an example to illustrate the point, but here are some important rules/facts needed to take on account:
1. The function will need to get different number of cells (in this example the input is only 5 cells but sometimes it will be 10 cells, sometimes 2, sometimes 100..etc,..)
2. The Cells are NOT located at the same location not located at the same order. Meaning, It could be T125, U125, V125 and also can be F33, I39, K108, M59.