Pretty1996
Board Regular
- Joined
- Apr 28, 2010
- Messages
- 100
Hi guys,
I'm hoping someone can help me here,
what I'm trying to do is first the first and last rows that contain a certain value and then select everything in between as a range.
so if for example cell B1 has the value "bbb" it will select A3:A5 as a range.
<TBODY>
</TBODY>
Hope I'm making sense guys, appreicate your help.
I'm using Excel 2010
I'm hoping someone can help me here,
what I'm trying to do is first the first and last rows that contain a certain value and then select everything in between as a range.
so if for example cell B1 has the value "bbb" it will select A3:A5 as a range.
Value |
aaa |
aaa |
bbb |
bbb |
bbb |
ccc |
<TBODY>
</TBODY>
Hope I'm making sense guys, appreicate your help.
I'm using Excel 2010