hi Ashish
First of all thaks.I tried your code but the color code index is not
working well,after the macro2()
running it fails to set color code index property, how can i solve it.
Regards
Rajesh kainikkara
On 11/17/10, OpenExcel.com wrote:
> Hi Rajesh,
>
> I modified your code. You may try thes
Hi Rajesh,
I modified your code. You may try these codes:
For Sheet1: Event Macro
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.EnableEvents = False
Columns(3).Interior.ColorIndex = xlNone
Cells(ActiveCell.Row, 3).Interior.Color = vbYellow
Applica