"Pete" wrote in message
...
Hi,

Can anyone tell me how to highlight cells in column A & B of the
active row, I wish this to be a Workbook command if possible.



I used the macro recorder to get trhis:

Range("A4:B4").Select
With Selection.Interior
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
.Color = 65535
.TintAndShade = 0
.PatternTintAndShade = 0
End With

I'd suggest that you use the macro recorder to discover what values give
you the highlight you want.

Then, I'd replace

Range("A4:B4").Select
With Selection.Interior

with

With ActiveCell.EntireRow.Columns("A:B").Interior

to highlight columns A and B of the active row.

--
Clif McIrvin

(clare reads his mail with moe, nomail feeds the bit bucket :-)