Copy a range to another "transformed" range

  • Thread starter Thread starter avi
  • Start date Start date
A

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
 
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
 
Back
Top