What help do you need in this macro??
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rash Sent: Monday, July 04, 2011 10:25 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Excel VBA for BOM Hi, With some more detailed explanation: I have data from col A till Col Y. Columns E to R are of no interest, So I am hiding those columns. 1. In Column 1 I have pos no 1 to 6. May increase till 1 to 10 in future. (But these are not always sorted in ascending order, can be jumbled sometimes like in row 137 to 142. Highlighted in Redcolor) 2. Between 1 to 6 in Col A, where ever there is change in component/ Sub assy in Col S have to be highlighted in some color. Like rows 28 to 33 and 58 to 64, 137 to 142, etc. All Highlighted. Hope this gives better clarification. Please find attached Excel sheet with highlighted rows. -- ---------------------------------------------------------------------------- ------ 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