Hello again mates,
I'd like to get two VBA codes in one worksheet for creating two-number or more-number sets.
A1=5
B1= empty or given value else 5
code1
It will start to increase B1 value one by one from 1 to 80
While increasing, when it comes to 5, it should skip it, bcuz I dont want to enter repeating value with cell A1.
code2
It will start to decrease B1 value one by one from 1 to 80
While decreasing, when it comes to 5, it should skip it, bcuz I dont want to enter repeating value with cell A1.
Note
If B1 is empty and code1 should start giving values from 1. If B1 is empty code2 should start giving values like 80,79,78,... So on.
If B1 has already value, such as 4, code1 should continue to increase like 6, 7, 8,... so on.
If B1 has already value, such as 6, code2 should continue to decrease like 4, 3, 2, 1, 80, 79, 78......
Please check it to see.
Thank you.
Bookmarks