Absolutely perfect mate :P may thanks
Alex cargill
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Kishan Reddy, K
Sent: 16 August 2010 08:13
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Re: Help needed in changing this
Just Try this code.
Dim CELL As Variant
Range("B2:B105").Select
For Each CELL In Selection
If IsEmpty(CELL) Then
With CELL.Offset(0, -1).Interior
.ColorIndex = 3
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
End With
Else
With C
