ManUBlueJay
Active Member
- Joined
- Aug 30, 2012
- Messages
- 302
- Office Version
- 2016
- Platform
- Windows
I have a number in A1.
I want that number to be found in range B1:B100
Then I need to find the next whole number after that. The Cells between is my dynamic range.
Example: A1 has 25
B1 to B10:
B1 12c
12d
B3 25
37b
12c
13d
B7 47
42a
51b
B10 12
So I want my Range to be B4:B6
I want that number to be found in range B1:B100
Then I need to find the next whole number after that. The Cells between is my dynamic range.
Example: A1 has 25
B1 to B10:
B1 12c
12d
B3 25
37b
12c
13d
B7 47
42a
51b
B10 12
So I want my Range to be B4:B6