You're welcome.
Regards - Dave
> Date: Mon, 25 Apr 2011 17:29:30 -0700
> Subject: Re: $$Excel-Macros$$ macro to add fill color to a column of selected
> range
> From: cje...@yahoo.com
> To: excel-macros@googlegroups.com
>
>
> That's excellent Dave. Exactl
That's excellent Dave. Exactly what I was looking for.
Thanks!!
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN
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
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
