$$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 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, Egypt -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel AutoFill.xlsm Description: Binary data
RE: $$Excel-Macros$$ How Can I Clear Content Autofill
I'll explain what 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 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, 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 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 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, Egypt -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Regards Ashish Koul akoul.blogspot.com http://akoul.posterous.com/ akoul.wordpress.com My Linkedin Profile P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
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, 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 = 19 Then Set abc = Range(s Target.Row :s Target.Row + Target.Rows.Count) For Each cell In abc Select Case cell.Value Case A cell.EntireRow.Interior.Color = RGB(192, 192, 192) Case B cell.EntireRow.Interior.Color = RGB(0, 0, 255) Case C cell.EntireRow.Interior.Color = RGB(255, 255, 0) Case Else cell.EntireRow.Interior.Color = xlNone End Select Next cell End If End Sub On Mon, Jul 4, 2011 at 9:44 PM, Ahmed galal ahmed.ga...@live.com wrote: I'll explain what 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 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 A Target.EntireRow.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 = xlNone End Select End If End Sub On Mon, Jul 4, 2011 at 7:51 PM, Ahmed galal ahmed.ga...@live.com wrote: Hi all I 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 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, Egypt -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Regards Ashish Koul akoul.blogspot.com http://akoul.posterous.com/ akoul.wordpress.com My Linkedin Profile P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Regards Ashish Koul akoul.blogspot.com http://akoul.posterous.com/ akoul.wordpress.com My Linkedin Profile P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel
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, Egypt From: jainayus...@gmail.com Date: Mon, 4 Jul 2011 22:48:33 +0530 Subject: $$Excel-Macros$$ Ashish Koul : Most Helpful Member - June'11 To: excel-macros@googlegroups.com Hello Everyone, Ashish Koul has been selected as 'Most Helpful Member' for the month of June'11 He has posted 53 posts in June 2011 and helped many people through his expertise. He has been consistent contributor to this excel forum and achieved this recognition from last seven months consecutively.This is really awesome. He is awarded Microsoft MVP 2011 award for his voluntary contribution. Thanks to Rajan, Venkat and other folks for helping excel enthusiasts !! keep it up !! Let see who becomes next MVP.. Keep posting. Regards Ayush Jain Group Manager -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ How to use Event Change to Change Color of Row
Hi all,I need to know how to use Event Change to Change Color of Row according to changing in specified Column cells.for example:I have column S any cell in it take code A,B,C,D,R W.I need when any cell change in the column S taken one of the previous 6 codes, then 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 62 60 61 Website : http://www.square.com.eg 31 Lebanon St. Mohandsen, Giza, Egypt -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
RE: $$Excel-Macros$$ How to use Event Change to Change Color of Row
Thanks ashish for code it helped me a lotnow i developed the code to be: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 19 And Target.Count = 1 Then Select Case Target.ValueCase ATarget.EntireRow.Interior.Color = RGB(192, 192, 192)Case CTarget.EntireRow.Interior.Color = RGB(255, 255, 0)Case CTarget.EntireRow.Interior.Color = RGB(255, 255, 0)Case CTarget.EntireRow.Interior.Color = RGB(255, 255, 0)Case CTarget.EntireRow.Interior.Color = RGB(255, 255, 0)Case CTarget.EntireRow.Interior.Color = 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 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, Egypt Date: Sun, 3 Jul 2011 20:41:40 +0530 Subject: Re: $$Excel-Macros$$ How to use Event Change to Change Color of Row From: koul.ash...@gmail.com To: excel-macros@googlegroups.com Private Sub Worksheet_Change(ByVal Target As Range) If Target.Count = 1 And Target.Column = 19 ThenRange(a Target.Row).Interior.Color = RGB(192, 192, 192) Range(b Target.Row).Interior.Color = RGB(192, 192, 192) Range(d Target.Row).Interior.Color = vbYellowRange(c Target.Row).Interior.Color = vbYellow Range(r Target.Row).Interior.Color = RGB(255, 0, 0)Range(w Target.Row).Interior.Color = vbGreenEnd If End Sub On Sun, Jul 3, 2011 at 5:45 PM, Ahmed galal ahmed.ga...@live.com wrote: Hi all,I need to know how to use Event Change to Change Color of Row according to changing in specified Column cells.for example:I have column S any cell in it take code A,B,C,D,R W. I need when any cell change in the column S taken one of the previous 6 codes, then the Row of it change to specified colorA,B = Grey ColorC,D = Yellow colorR = Reed Color W = 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 31 Lebanon St. Mohandsen, Giza, Egypt -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Regards Ashish Koul akoul.blogspot.com http://akoul.posterous.com/ akoul.wordpress.com My Linkedin Profile P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel