I have a procedure which appends several columns to a given named
range. Each of these new columns I add to the range are either a
formula or a UDF (eg converts Julian date to 'normal' date).

Currently I have a large procedure which does this where the coding
differs for each column. (15 columns and counting). I'd like to have
two procedures do this job. Specifcally, I would like my first
procedure to list the columns to add, and the second to add them. I'm
attempting to this by passing values to the second procedure eg the
column title as string, the named range as string, the formula or the
UDF as string.

Other Points:
-If it's a formula I want the formula to be displayed not just the
value.
-The value generated by the UDF will vary depending upon the values in
the row. (ie the Julian date). I have only one column which uses a UDF
to calculate the value, but this will no doubt change in the future.

I'm trying to use the evaluate method in the second procedure , but not
having much joy.

Any thoughts would be well received.


Regards
Mohsen (using Excel French/ 2003 + 2000)