Inserting a function into a worksheet
 

I have a function (from cpearson.com) to add numbers in a column that are a
certain color. Now, a very elementary (I'm sure) question: How and where do
I enter this function so I can execute it? I've entered it into the
Microsoft Visual Basic Window. but I don't know how to get it onto the
worksheet in an executable manner. Thanks,

Rich D
Armstrong Custom Homes
Redmond

Inserting a function into a worksheet
 

Alt + F11 opens the VB editor. Right click on the project and insert a new
module and paste the function into the module.

It can be called from a worksheet by using the function name and passing the
necessary values to it.

"Rich D" wrote:

I have a function (from cpearson.com) to add numbers in a column that are a
certain color. Now, a very elementary (I'm sure) question: How and where do
I enter this function so I can execute it? I've entered it into the
Microsoft Visual Basic Window. but I don't know how to get it onto the
worksheet in an executable manner. Thanks,

Rich D
Armstrong Custom Homes
Redmond