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