Prev: macro to insert row and type data
Next: another filtering question
From: FreeBird on 7 Jun 2010 09:49

Hello,


Union(Cells.SpecialCells(xlCellTypeFormulas, 23),
Cells.SpecialCells(xlCellTypeAllFormatConditions)).Interior.Color =
RGB(0, 255, 0)

you may have to complete the formula selection.

bye




a
n
d
r
e
a
s
h
e
r
m
l
e
;
7
3
9
2
6
5

W
r
o
t
e
:


>
Dear Experts:
>
> I got cells in one table of a worksheet that contain ...
>
> .... formulas as well as conditional formatting (i.e. there are cells
> that contain both attributes)
>
> I would like to fill these cells (containing formulas as well as
> conditional formatting at the same time) with a certain shadefill (RGB
> 177, 177, 177) with the aid of a VBA macro.
>
> Help is much appreciated. Thank you very much in advance.
>
> Regards, Andreas


--
FreeBird
------------------------------------------------------------------------
FreeBird's Profile: http://www.thecodecage.com/forumz/member.php?u=1701
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=207509

http://www.thecodecage.com/forumz

 | 
Pages: 1
Prev: macro to insert row and type data
Next: another filtering question