Copy a range to another "transformed" range

[avi]

Hello,

Is there a way to copy a one column range to another range of the same
size, but with some transformed values of the original range, for
example Log of the original values?

Thanks
Avi

 

[Patrick Molloy]

why not use worksheet formulae?

 

[avi]

I am looking for a VBA procedure that automatically copy the
OriginalRange and paste it "transformed" to another location

The procedure should work with one column range and do something like

set OriginalRange=Selection
OriginalRange.copy
Cells(1,100).select
Calculate the Log of the original range
Paste the "transformed" selection starting from Cells(1,100)

Thanks
Avi