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

Reply via email to