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?
|