Marcke
12-11-2008, 06:43 AM
Hi,
I'd like to move some columns and use paste as value. Can I do this with vba?
Thanks in advance,
Wannes
'Paste as value should be used
shCalculations.Select
Range("getFirstCalculationColumn:getFirstCalculationColumn+getNumberOfDaysArchived-1").Copy
Range("getFirstCalculationColumn+1:getFirstCalculationColumn+getNumberOfDaysArchiv ed").Paste
I'd like to move some columns and use paste as value. Can I do this with vba?
Thanks in advance,
Wannes
'Paste as value should be used
shCalculations.Select
Range("getFirstCalculationColumn:getFirstCalculationColumn+getNumberOfDaysArchived-1").Copy
Range("getFirstCalculationColumn+1:getFirstCalculationColumn+getNumberOfDaysArchiv ed").Paste