I found the coding on the Pearson website for how to count cells based on the
color of the cell. WOW! That is just what I have been trying to figure out,
and it works perfectly.

I want to be able to access that coding no matter what workbook I open,
without having to copy the module from one workbook to another each time. I
tried saving it in my Personal Macro Workbook, but that didn't work.

Any suggestions?

What happened when it didn't work?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"KristiB" wrote in message
...
I found the coding on the Pearson website for how to count cells based on
the
color of the cell. WOW! That is just what I have been trying to figure
out,
and it works perfectly.

I want to be able to access that coding no matter what workbook I open,
without having to copy the module from one workbook to another each time.
I
tried saving it in my Personal Macro Workbook, but that didn't work.

Any suggestions?

I get a #NAME? error, so it is not recognizing the =countbycolor function in
the new workbook.

KB

"Bob Phillips" wrote:

What happened when it didn't work?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"KristiB" wrote in message
...
I found the coding on the Pearson website for how to count cells based on
the
color of the cell. WOW! That is just what I have been trying to figure
out,
and it works perfectly.

I want to be able to access that coding no matter what workbook I open,
without having to copy the module from one workbook to another each time.
I
tried saving it in my Personal Macro Workbook, but that didn't work.

Any suggestions?

try

=personal.xls!countybycolor(...

"KristiB" wrote:

I get a #NAME? error, so it is not recognizing the =countbycolor function in
the new workbook.

KB

"Bob Phillips" wrote:

What happened when it didn't work?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"KristiB" wrote in message
...
I found the coding on the Pearson website for how to count cells based on
the
color of the cell. WOW! That is just what I have been trying to figure
out,
and it works perfectly.

I want to be able to access that coding no matter what workbook I open,
without having to copy the module from one workbook to another each time.
I
tried saving it in my Personal Macro Workbook, but that didn't work.

Any suggestions?

That worked!

Thanks bunches!

KB

"Duke Carey" wrote:

try

=personal.xls!countybycolor(...

"KristiB" wrote:

I get a #NAME? error, so it is not recognizing the =countbycolor function in
the new workbook.

KB

"Bob Phillips" wrote:

What happened when it didn't work?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"KristiB" wrote in message
...
I found the coding on the Pearson website for how to count cells based on
the
color of the cell. WOW! That is just what I have been trying to figure
out,
and it works perfectly.

I want to be able to access that coding no matter what workbook I open,
without having to copy the module from one workbook to another each time.
I
tried saving it in my Personal Macro Workbook, but that didn't work.

Any suggestions?

Just adding to the others' posts, if you put the function in an
Add-In, you don't need to prefix the call with the workbook name.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"KristiB" wrote in message
...
I found the coding on the Pearson website for how to count cells
based on the
color of the cell. WOW! That is just what I have been trying
to figure out,
and it works perfectly.

I want to be able to access that coding no matter what workbook
I open,
without having to copy the module from one workbook to another
each time. I
tried saving it in my Personal Macro Workbook, but that didn't
work.

Any suggestions?