| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average Function (include Blank Cells and Zeros) | Excel Discussion (Misc queries) | |||
| Passing a WorkSheet from a Function??? | Excel Worksheet Functions | |||
| Adding a Function to a cell when inserting a row from a macro | Excel Worksheet Functions | |||
| numerical integration | Excel Discussion (Misc queries) | |||
| changing type style and colour within a worksheet function | Excel Worksheet Functions | |||
Linear Mode
