Hi. Am new to Excel, having a problem, seems like it's something
trivial.

I need it to check a given cell, and if that cell is bold, then for it
to bold _a_range_ of cells (ie not just one, nor the entire row).

For a single cell (say the one next to it) I would just put
If ActiveCell.Font.Bold = True Then
ActiveCell.Offset(0, 1).Font.Bold = True

And for the entire row:
If ActiveCell.Font.Bold = True Then
ActiveCell.EntireRow.Font.Bold = True

but how do I specify a given range? (say A1 is the cell for checking
and B1:B100 the range to be bolded if necessary). I should add this is
part of a loop (ie there are, say, 50 rows to be checked).

Many thanks for any help


--
Winawer
------------------------------------------------------------------------
Winawer's Profile: http://www.excelforum.com/member.php...o&userid=33978
View this thread: http://www.excelforum.com/showthread...hreadid=537509