The macro will fill the formulas into columns B and C essentially
instantaneously using a loop. You don't need to write in any formulas unless
I don't understand your situation. Example where functions f and g are very
simple UDF's:

Sub Test()
Dim c As Range
For Each c In Range("NamesRng")
c(1, 2).Formula = "=f(" & c.Address(False, False, xlA1) & ")"
c(1, 3).Formula = "=g(" & c.Address(False, False, xlA1) & ")"
Next
End Sub

Function f(txt As String) As String
f = Left(txt, 3) & Len(txt)
End Function

Function g(txt As String) As String
g = Len(txt) & Right(txt, 3)
End Function

The AutoFill method should only take seconds. Don't copy/paste. To AutoFill:
1. Select the top cell containing a formula in column B.
2. Move the mouse pointer over top of the little black square at the
bottom-right corner of the cell. The mouse pointer should convert to a plus
sign ("+").
3. Hold down the left mouse button and drag down till it fills the range.
The cell references should increment as required.

Regards,
Greg

"dreamz" wrote:


thanks for the reply.

i used to put the formula into the top cells and then copy down. i
haven't tried filldown, but is it slow or inefficient? is it worse than
trying to do something with the "value" method?

and the second one may not work as well, especially since i'd need to
write out all the formulas.


--
dreamz
------------------------------------------------------------------------
dreamz's Profile: http://www.excelforum.com/member.php...o&userid=26462
View this thread: http://www.excelforum.com/showthread...hreadid=533040