jerry12302
Active Member
- Joined
- Apr 18, 2005
- Messages
- 449
- Office Version
- 2010
- Platform
- Windows
I have trending data and would like to circle certain ranges of data that meet certain criteria. I have code that predefines the cell ranges that need to be circled, but I don't know how to automate the drawing of the rounded rectangles so that they circle specific cells.
I would like them to be exactly uniform in width, and for the corners to be fully rounded. The lengths would vary based on how many cells need to be circled.
In my example, D2 through F2 should be circled, and C3 through E3. Also, some data is vertical, as shown, and I would want B9 through B12 circled in the example.
Assume the cells defining the first and last cell are defined, how do I write code to automate the circling of the data with rounded rectangles?
I would like them to be exactly uniform in width, and for the corners to be fully rounded. The lengths would vary based on how many cells need to be circled.
In my example, D2 through F2 should be circled, and C3 through E3. Also, some data is vertical, as shown, and I would want B9 through B12 circled in the example.
Assume the cells defining the first and last cell are defined, how do I write code to automate the circling of the data with rounded rectangles?
Book1 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
1 | ||||||||||
2 | 10 | 20 | 35 | 37 | 48 | 50 | 60 | |||
3 | 17 | 40 | 50 | 60 | 66 | 45 | 67 | |||
4 | ||||||||||
5 | 10 | |||||||||
6 | 20 | |||||||||
7 | 45 | |||||||||
8 | 34 | |||||||||
9 | 60 | |||||||||
10 | 70 | |||||||||
11 | 80 | |||||||||
12 | 90 | |||||||||
Sheet1 |