Select Section between blank rows

srschicago

Board Regular
Joined
Apr 14, 2017
Messages
59
Hey Team,
I have a worksheet with data in columns A thu E that is broken into sections separated by blank rows and a unique "Title" in column A starting each section. I need to select the col A range of a section so that I can format each column differently. CurrentRegion doesn't do it because I need to resize and offset the selection.
Thanks in advance for your help.
 

Some videos you may like

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
11,238
Office Version
2007
Platform
Windows
In the following example you can explain what you need to select.


<table border="1" cellspacing="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:96.95px;" /><col style="width:76.04px;" /><col style="width:76.04px;" /><col style="width:76.04px;" /><col style="width:76.04px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td><td >C</td><td >D</td><td >E</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td >Title section1</td><td >b1</td><td >c1</td><td >d1</td><td >e1</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td > </td><td >b2</td><td >c2</td><td >d2</td><td >e2</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td > </td><td >b3</td><td >c3</td><td >d3</td><td >e3</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td > </td><td >b4</td><td >c4</td><td >d4</td><td >e4</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td >Title section2</td><td >b5</td><td >c5</td><td >d5</td><td >e5</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td > </td><td >b6</td><td >c6</td><td >d6</td><td >e6</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td > </td><td >b7</td><td >c7</td><td >d7</td><td >e7</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td > </td><td >b8</td><td >c8</td><td >d8</td><td >e8</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td >Title section3</td><td >b9</td><td >c9</td><td >d9</td><td >e9</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td > </td><td >b10</td><td >c10</td><td >d10</td><td >e10</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td > </td><td >b11</td><td >c11</td><td >d11</td><td >e11</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >12</td><td > </td><td >b12</td><td >c12</td><td >d12</td><td >e12</td></tr></table> <br /><br />
 

srschicago

Board Regular
Joined
Apr 14, 2017
Messages
59
In the following example you can explain what you need to select.


ABCDE
1Title section1b1c1d1e1
2b2c2d2e2
3b3c3d3e3
4b4c4d4e4
5Title section2b5c5d5e5
6b6c6d6e6
7b7c7d7e7
8b8c8d8e8
9Title section3b9c9d9e9
10b10c10d10e10
11b11c11d11e11
12b12c12d12e12

<tbody>
</tbody>
The data is also in column A. There is no data in b,c,d,e of the title row. There are entirely blank rows between each section. I need to select the data range directly below the title in Column A and ending with the next blank row. I am sorry for the confusion
 
Last edited:

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
11,238
Office Version
2007
Platform
Windows
I'm still confused, could you explain with data, what do you have and what do you need to select?
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
38,933
Office Version
365
Platform
Windows
Is your data like

<b>Excel 2013/2016</b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px" style="background-color: rgb(218,231,245)" /><col /><col /><col /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: rgb(218,231,245);text-align: center;color: rgb(22,17,32)"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th><th>G</th><th>H</th><th>I</th></tr></thead><tbody><tr ><td style="color: rgb(22,17,32);text-align: center;">1</td><td style=";">District</td><td style=";">Ward</td><td style=";">Postcode</td><td style=";">In Use?</td><td style=";">Latitude</td><td style=";">Longitude</td><td style=";">Easting</td><td style=";">Northing</td><td style=";">GridRef</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">2</td><td style=";">Bedfordshire</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">3</td><td style="background-color: #8DC182;;">Luton</td><td style="background-color: #8DC182;;">Biscot</td><td style="background-color: #8DC182;;">LU1 1HP</td><td style="background-color: #8DC182;;">Yes</td><td style="text-align: right;background-color: #8DC182;;">51.884074</td><td style="text-align: right;background-color: #8DC182;;">-0.424657</td><td style="text-align: right;background-color: #8DC182;;">508524</td><td style="text-align: right;background-color: #8DC182;;">221785</td><td style="background-color: #8DC182;;">TL085217</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">4</td><td style="background-color: #8DC182;;">Luton</td><td style="background-color: #8DC182;;">South</td><td style="background-color: #8DC182;;">LU1 1WF</td><td style="background-color: #8DC182;;">No</td><td style="text-align: right;background-color: #8DC182;;">51.879978</td><td style="text-align: right;background-color: #8DC182;;">-0.422926</td><td style="text-align: right;background-color: #8DC182;;">508653</td><td style="text-align: right;background-color: #8DC182;;">221332</td><td style="background-color: #8DC182;;">TL086213</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">5</td><td style="background-color: #8DC182;;">Luton</td><td style="background-color: #8DC182;;">South</td><td style="background-color: #8DC182;;">LU1 3RG</td><td style="background-color: #8DC182;;">Yes</td><td style="text-align: right;background-color: #8DC182;;">51.868744</td><td style="text-align: right;background-color: #8DC182;;">-0.417989</td><td style="text-align: right;background-color: #8DC182;;">509020</td><td style="text-align: right;background-color: #8DC182;;">220090</td><td style="background-color: #8DC182;;">TL090200</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">6</td><td style="background-color: #8DC182;;">Luton</td><td style="background-color: #8DC182;;">Farley</td><td style="background-color: #8DC182;;">LU1 5TT</td><td style="background-color: #8DC182;;">No</td><td style="text-align: right;background-color: #8DC182;;">51.87459</td><td style="text-align: right;background-color: #8DC182;;">-0.430204</td><td style="text-align: right;background-color: #8DC182;;">508165</td><td style="text-align: right;background-color: #8DC182;;">220722</td><td style="background-color: #8DC182;;">TL081207</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">7</td><td style="background-color: #8DC182;;">Luton</td><td style="background-color: #8DC182;;">Round Green</td><td style="background-color: #8DC182;;">LU2 7JH</td><td style="background-color: #8DC182;;">Yes</td><td style="text-align: right;background-color: #8DC182;;">51.89104</td><td style="text-align: right;background-color: #8DC182;;">-0.407745</td><td style="text-align: right;background-color: #8DC182;;">509671</td><td style="text-align: right;background-color: #8DC182;;">222585</td><td style="background-color: #8DC182;;">TL096225</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">8</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">9</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">10</td><td style=";">Berkshire</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">11</td><td style="background-color: #B3D6AB;;">Reading</td><td style="background-color: #B3D6AB;;">Abbey</td><td style="background-color: #B3D6AB;;">RG1 1UQ</td><td style="background-color: #B3D6AB;;">No</td><td style="text-align: right;background-color: #B3D6AB;;">51.460727</td><td style="text-align: right;background-color: #B3D6AB;;">-0.974799</td><td style="text-align: right;background-color: #B3D6AB;;">471321</td><td style="text-align: right;background-color: #B3D6AB;;">174026</td><td style="background-color: #B3D6AB;;">SU713740</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">12</td><td style="background-color: #B3D6AB;;">Reading</td><td style="background-color: #B3D6AB;;">Katesgrove</td><td style="background-color: #B3D6AB;;">RG1 2PY</td><td style="background-color: #B3D6AB;;">Yes</td><td style="text-align: right;background-color: #B3D6AB;;">51.447595</td><td style="text-align: right;background-color: #B3D6AB;;">-0.971237</td><td style="text-align: right;background-color: #B3D6AB;;">471589</td><td style="text-align: right;background-color: #B3D6AB;;">172569</td><td style="background-color: #B3D6AB;;">SU715725</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">13</td><td style="background-color: #B3D6AB;;">Reading</td><td style="background-color: #B3D6AB;;">Abbey</td><td style="background-color: #B3D6AB;;">RG1 3EQ</td><td style="background-color: #B3D6AB;;">Yes</td><td style="text-align: right;background-color: #B3D6AB;;">51.455808</td><td style="text-align: right;background-color: #B3D6AB;;">-0.958401</td><td style="text-align: right;background-color: #B3D6AB;;">472468</td><td style="text-align: right;background-color: #B3D6AB;;">173495</td><td style="background-color: #B3D6AB;;">SU724734</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">14</td><td style="background-color: #B3D6AB;;">Reading</td><td style="background-color: #B3D6AB;;">Redlands</td><td style="background-color: #B3D6AB;;">RG1 4NX</td><td style="background-color: #B3D6AB;;">Yes</td><td style="text-align: right;background-color: #B3D6AB;;">51.453604</td><td style="text-align: right;background-color: #B3D6AB;;">-0.957343</td><td style="text-align: right;background-color: #B3D6AB;;">472545</td><td style="text-align: right;background-color: #B3D6AB;;">173251</td><td style="background-color: #B3D6AB;;">SU725732</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">15</td><td style="background-color: #B3D6AB;;">Reading</td><td style="background-color: #B3D6AB;;">Minster</td><td style="background-color: #B3D6AB;;">RG1 6LB</td><td style="background-color: #B3D6AB;;">Yes</td><td style="text-align: right;background-color: #B3D6AB;;">51.448354</td><td style="text-align: right;background-color: #B3D6AB;;">-0.987207</td><td style="text-align: right;background-color: #B3D6AB;;">470478</td><td style="text-align: right;background-color: #B3D6AB;;">172638</td><td style="background-color: #B3D6AB;;">SU704726</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">16</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">17</td><td style=";">Cambridgeshire</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">18</td><td style="background-color: #8DC182;;">Cambridge</td><td style="background-color: #8DC182;;">Abbey</td><td style="background-color: #8DC182;;">CB1 0EY</td><td style="background-color: #8DC182;;">No</td><td style="text-align: right;background-color: #8DC182;;">52.209345</td><td style="text-align: right;background-color: #8DC182;;">0.148231</td><td style="text-align: right;background-color: #8DC182;;">546881</td><td style="text-align: right;background-color: #8DC182;;">258966</td><td style="background-color: #8DC182;;">TL468589</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">19</td><td style="background-color: #8DC182;;">Cambridge</td><td style="background-color: #8DC182;;">Market</td><td style="background-color: #8DC182;;">CB1 1HW</td><td style="background-color: #8DC182;;">Yes</td><td style="text-align: right;background-color: #8DC182;;">52.207754</td><td style="text-align: right;background-color: #8DC182;;">0.134806</td><td style="text-align: right;background-color: #8DC182;;">545969</td><td style="text-align: right;background-color: #8DC182;;">258762</td><td style="background-color: #8DC182;;">TL459587</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">20</td><td style="background-color: #8DC182;;">Cambridge</td><td style="background-color: #8DC182;;">Trumpington</td><td style="background-color: #8DC182;;">CB1 2EH</td><td style="background-color: #8DC182;;">Yes</td><td style="text-align: right;background-color: #8DC182;;">52.199596</td><td style="text-align: right;background-color: #8DC182;;">0.130493</td><td style="text-align: right;background-color: #8DC182;;">545701</td><td style="text-align: right;background-color: #8DC182;;">257846</td><td style="background-color: #8DC182;;">TL457578</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">21</td><td style="background-color: #8DC182;;">Cambridge</td><td style="background-color: #8DC182;;">Petersfield</td><td style="background-color: #8DC182;;">CB1 2TF</td><td style="background-color: #8DC182;;">No</td><td style="text-align: right;background-color: #8DC182;;">52.201419</td><td style="text-align: right;background-color: #8DC182;;">0.137561</td><td style="text-align: right;background-color: #8DC182;;">546178</td><td style="text-align: right;background-color: #8DC182;;">258063</td><td style="background-color: #8DC182;;">TL461580</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">22</td><td style="background-color: #8DC182;;">Cambridge</td><td style="background-color: #8DC182;;">Romsey</td><td style="background-color: #8DC182;;">CB1 3HN</td><td style="background-color: #8DC182;;">Yes</td><td style="text-align: right;background-color: #8DC182;;">52.202139</td><td style="text-align: right;background-color: #8DC182;;">0.15384</td><td style="text-align: right;background-color: #8DC182;;">547288</td><td style="text-align: right;background-color: #8DC182;;">258176</td><td style="background-color: #8DC182;;">TL472581</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">23</td><td style="background-color: #8DC182;;">Cambridge</td><td style="background-color: #8DC182;;">Coleridge</td><td style="background-color: #8DC182;;">CB1 4HF</td><td style="background-color: #8DC182;;">No</td><td style="text-align: right;background-color: #8DC182;;">52.18618</td><td style="text-align: right;background-color: #8DC182;;">0.153244</td><td style="text-align: right;background-color: #8DC182;;">547300</td><td style="text-align: right;background-color: #8DC182;;">256400</td><td style="background-color: #8DC182;;">TL473564</td></tr></tbody></table><p style="width:3.2em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid rgb(187,187,187);border-top:none;text-align: center;background-color: rgb(218,231,245);color: rgb(22,17,32)">List</p><br /><br />

Where you need to select the areas in green
 

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
11,238
Office Version
2007
Platform
Windows
You need to format each column for example:

<table border="1" cellspacing="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:96.95px;" /><col style="width:76.04px;" /><col style="width:76.04px;" /><col style="width:76.04px;" /><col style="width:76.04px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td><td >C</td><td >D</td><td >E</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td >Title section1</td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="background-color:#ffff00; ">a2</td><td style="background-color:#92d050; ">b2</td><td style="background-color:#00b0f0; ">c2</td><td style="background-color:#7030a0; ">d2</td><td style="background-color:#f79646; ">e2</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td style="background-color:#ffff00; ">a3</td><td style="background-color:#92d050; ">b3</td><td style="background-color:#00b0f0; ">c3</td><td style="background-color:#7030a0; ">d3</td><td style="background-color:#f79646; ">e3</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td style="background-color:#ffff00; ">a4</td><td style="background-color:#92d050; ">b4</td><td style="background-color:#00b0f0; ">c4</td><td style="background-color:#7030a0; ">d4</td><td style="background-color:#f79646; ">e4</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td >Title section2</td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td style="background-color:#ffff00; ">a7</td><td style="background-color:#92d050; ">b6</td><td style="background-color:#00b0f0; ">c6</td><td style="background-color:#7030a0; ">d6</td><td style="background-color:#f79646; ">e6</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td style="background-color:#ffff00; ">a8</td><td style="background-color:#92d050; ">b7</td><td style="background-color:#00b0f0; ">c7</td><td style="background-color:#7030a0; ">d7</td><td style="background-color:#f79646; ">e7</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td style="background-color:#ffff00; ">a9</td><td style="background-color:#92d050; ">b8</td><td style="background-color:#00b0f0; ">c8</td><td style="background-color:#7030a0; ">d8</td><td style="background-color:#f79646; ">e8</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td >Title section3</td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >12</td><td style="background-color:#ffff00; ">a10</td><td style="background-color:#92d050; ">b10</td><td style="background-color:#00b0f0; ">c10</td><td style="background-color:#7030a0; ">d10</td><td style="background-color:#f79646; ">e10</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >13</td><td style="background-color:#ffff00; ">a11</td><td style="background-color:#92d050; ">b11</td><td style="background-color:#00b0f0; ">c11</td><td style="background-color:#7030a0; ">d11</td><td style="background-color:#f79646; ">e11</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >14</td><td style="background-color:#ffff00; ">a12</td><td style="background-color:#92d050; ">b12</td><td style="background-color:#00b0f0; ">c12</td><td style="background-color:#7030a0; ">d12</td><td style="background-color:#f79646; ">e12</td></tr></table>
 

srschicago

Board Regular
Joined
Apr 14, 2017
Messages
59
The example with different color columns is what my data looks like. The first row after the title is a header row, but as long as I get the colored range in column A, I can do the rest. Thanks for your help!
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
38,933
Office Version
365
Platform
Windows
How about
Code:
Sub srschicago()
   Dim Rng As Range
   For Each Rng In Range("A:A").SpecialCells(xlConstants).Areas
      Rng.Offset(2).Resize(Rng.Count - 2).Interior.Color = vbYellow
   Next Rng
End Sub
If you want to include the header row change the 2s to 1s
 
Last edited:

Rick Rothstein

MrExcel MVP
Joined
Apr 18, 2011
Messages
35,817
Office Version
2010
Platform
Windows
How about
Code:
Sub srschicago()
   Dim Rng As Range
   For Each Rng In Range("A:A").SpecialCells(xlConstants).Areas
      Rng.Offset(2).Resize(Rng.Count - 2).Interior.Color = vbYellow
   Next Rng
End Sub
If you want to include the header row change the 2s to 1s
If that does what the OP wants, then I think this will also (change the one 2 to a 1 to include the headers)...
Code:
Sub srschicago2()
  Range("A:A").SpecialCells(xlConstants).Offset(2).Interior.Color = vbYellow
  Range("A:A").SpecialCells(xlBlanks).Interior.Color = xlNone
  Range("A:A").SpecialCells(xlBlanks).Offset(1).Interior.Color = xlNone
End Sub
 

srschicago

Board Regular
Joined
Apr 14, 2017
Messages
59
I guess I am not being clear enough. I need to select the column A range immediately below the Section 2 title cell up to the next blank cell in Col A
I am then going to offset the range to select column B and gray fill those cells.
Then offset and resize to include all columns and apply borders to Col A:E in the selected rows. (All Section 2 data)
Note: There is a date in the Col C cell of the row immediately below this data that I want to delete as well (to make the entire row truly blank).
So I need the address of the last row of the section two Col A data as well (or the blank cell below it, which will be the row I clear of the date in Col C)
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,096,065
Messages
5,448,187
Members
405,490
Latest member
Larry of Oz

This Week's Hot Topics

Top