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

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,

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

eRow.Interior.Color = RGB(192, 192, 192) Case "B"Target.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 wro

$$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 Eng

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

olor = RGB(255, 255, 0)End SelectEnd IfEnd Sub everything is ok., but when i 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 Pr

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

hen the Row of it change 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