Hey thanks for the information. But! I can find the insert function dialog
box but I can't find out how to insert and write functions Am I supposed to
do that in the VBA environment?

Thanks, You must have a million questions to answer!



"Gary''s Student" wrote:

You can do it if your VBA code is a function. If you can somehow enclose
your code in a UDF, then the UDF can be used in the woorkshhet.


See my posting earlier today w.r.t. Using VBA Functions in a worksheet.
--
Gary''s Student


"DMB" wrote:

Is there a way to call a procedure that I have already written in vba from a
cell. For instance, can I put something like the following into a cell

Call CopyFunctionToAdjacentCell()


This is the VBA Code that I am using right now. It works great. If I could
only cut and paste it into the cell I would be set.
Cells(4 + StartRow, 4) = "'" & Cells(4 + StartRow, 2).Formula

Is thee a way to accomplish the same thing within Excel?
=A1.Formula ???

Problem is that I always get the result on the equation.