ExcelBanter - View Single Post

Stopher

wrote:

I'm trying to write a macro that can automatically select a range of
cells (across rows & columns) based on the format (bold) of the cells
above it and below it (also bold) so they can be sorted by date (which
is in one of the columns in the range). Now while the range of columns
will remain steady the number of rows will vary (and some in the
worksheet will not nedd to be sorted at all (having singular entries).
I know I can use the Offset property to select the rows below and
above, but can't figure a way of selecting the range of cells between
the two bolded cells. Does anyone know how to do this?

So you have something like

<boldABC</bold
AEF
AEG
<boldADF</bold

hope the html worked

So you would select the range ABC,AEF,AEG and ADF??

Stopher