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