Hi allI choose a specific Column Such as X Column and when one cell change it's
return a value in another cell in another column.now i need to make Auto-fill
or Clear Content to act on all row content, plz see the attachment
Best regards,
Ahmed
galal Mohamed
Procurement
Engineer
try this see if it helps
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 19 And Target.Count = 1 Then
Select Case Target.Value
Case A
Target.EntireRow.Interior.Color = RGB(192, 192, 192)
Case B
Target.EntireRow.Interior.Color = RGB(0, 0, 255)
Case C
$$ How Can I Clear Content Autofill
From: koul.ash...@gmail.com
To: excel-macros@googlegroups.com
try this see if it helps
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 19 And Target.Count = 1 Then
Select Case Target.Value
Case ATarget.EntireRow.Interior.Color = RGB(192, 192
the problem:-
try to pull + for cell to auto fill code like A into 3 cells down it will
return error, also if u select more than one cell including codes and delete
selection contents it returns error also.
Date: Mon, 4 Jul 2011 21:27:49 +0530
Subject: Re: $$Excel-Macros$$ How Can I Clear Content
, Egypt
Date: Mon, 4 Jul 2011 22:18:37 +0530
Subject: Re: $$Excel-Macros$$ How Can I Clear Content Autofill
From: koul.ash...@gmail.com
To: excel-macros@googlegroups.com
try this code-
Private Sub Worksheet_Change(ByVal Target As Range)
Dim cell As Range
Dim abc As Range
If Target.Column