$$Excel-Macros$$ How Can I Clear Content Autofill

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

RE: $$Excel-Macros$$ How Can I Clear Content Autofill

, 192) Case BTarget.EntireRow.Interior.Color = RGB(0, 0, 255) Case C Target.EntireRow.Interior.Color = RGB(255, 255, 0)Case Else Target.EntireRow.Interior.Color = xlNoneEnd SelectEnd IfEnd Sub On Mon, Jul 4, 2011 at 7:51 PM, Ahmed galal ahmed.ga...@live.com wrote: Hi allI choose a specific

RE: $$Excel-Macros$$ How Can I Clear Content Autofill

Excellent ashish, it's work nowthanks a lot Best regards, Ahmed galal Mohamed Procurement Engineer Head Office : SQUARE Engineering Firm Tel :(202) 2402 8846 Fax :(202) 2405 0476 Mobile :(010) 9 62 60 61 Website : http://www.square.com.eg 31 Lebanon St. Mohandsen, Giza

RE: $$Excel-Macros$$ Ashish Koul : Most Helpful Member - June'11

Congratulations Ashish, you deserve it. Best regards, Ahmed galal Mohamed Procurement Engineer Head Office : SQUARE Engineering Firm Tel :(202) 2402 8846 Fax :(202) 2405 0476 Mobile :(010) 9 62 60 61 Website : http://www.square.com.eg 31 Lebanon St. Mohandsen, Giza

$$Excel-Macros$$ How to use Event Change to Change Color of Row

to specified colorA,B = Grey ColorC,D = Yellow colorR = Reed ColorW = Green Color Best regards, Ahmed galal Mohamed Procurement Engineer Head Office : SQUARE Engineering Firm Tel :(202) 2402 8846 Fax :(202) 2405 0476 Mobile :(010) 9 62 60 61 Website : http://www.square.com.eg

RE: $$Excel-Macros$$ How to use Event Change to Change Color of Row

pull + for any cell to Repeat letter A for example to fill more than on cell automatically color fill also, it's return an error to me, how can i avoid it?? Best regards, Ahmed galal Mohamed Procurement Engineer Head Office : SQUARE Engineering Firm Tel :(202) 2402 8846 Fax