in the box.
Debug.Print CellColor.address
Debug.Print CellColor.Interior.ColorIndex
Stop
Any ideas on why the Color Macro is not working. The Macro is down below.
What can I do to get this to work?
Thanks,
Ty
Here is the Macro:
Function CountByColor(CellColor As Range, CountRang
)
z = z + lastrow
Next
End With
End Sub
Thanks,
Ty
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate
the
spreadsheet I have open now only have 1 Row Label. No problems.
Any help will be greatly appreciated.
Thanks,
Ty
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http
More information: I just played with it a little. Now, I can see
that it is suck on the first filter. It never changes. And this is
on the simple spreadsheet that I thought was working.
On Jul 16, 8:40 am, Ty tyrone_...@yahoo.com wrote:
My problem: Sometimes when I change my Report Filter
Hi,
I’ve seen a few queries that are similar to mine, but I can’t get any
of them to work for me. I am very grateful for any assistance that you
able to give.
I have a spreadsheet like this: (Sheet name: Input)
Col A: Sales person name
Col B: Unit
Col C to Z other data
Col A Clo b Col C