This is probably a really simple question but I haven't been able to find the
right VBA language to make it happen yet. I have a report that I need to add
a formula to in column "C". I want this formula to be copied into each cell
in column "C" until there are no more active rows. Then I want to highlight
the cells that I just filled with the formula, copy them and paste special
(values). Here's what I have so far. It looks like it will only handle the
absolute range of "C3:C93". Any ideas?

Range("C3").Select
Selection.AutoFill Destination:=Range("C3:C93")
Range("C3:C93").Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False

Thanks,

Have_Data_Will_Travel