Hi, Something like: Dim c as Range For each c in Selection If c.Column = 6 then c.Interior.Colorindex = 3 Next c
Note: Colorindex 6 will give you red. Change the number to suit. Regards - Dave. > Date: Sat, 23 Apr 2011 14:17:08 -0700 > Subject: $$Excel-Macros$$ macro to add fill color to a column of selected > range > From: cje...@yahoo.com > To: excel-macros@googlegroups.com > > > I have a ~500 rows of data in columns A-G. Several contiguous rows of > this data (columns A-G) will be selected. I would like my macro to > fill column F of the selected cells with color without losing the > original selection because these selected cells are used later in the > macro. > > I've been able to fill all selected cells with color but I would like > column F only. > > I might be able to increment through each row of the macro to test if > that cell has been selected but I'm thinking that this method would > cause a delay as it tested every row. I was looking for a more > straightforward method. > > Thank you for any help. > > -- > ---------------------------------------------------------------------------------- > 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