Division amidst aggregation macro?

[efader]

Hi:

I am aggregating data from multiple workbooks into one workbook. Due
to the way some of the data is formatted, I want to divide one of the
metrics by 100 prior to the macro pasting it into the aggregated
workbook.

How can I accomplish this?

Thanks,
Eric

 

[Jim Cone]

Dim X as Double
X = Range("B5").Value
Range("B5").Value = Range("B5").Value / 100
ActiveSheet.UsedRange.Copy
Range("B5").Value = X
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"efader"

I am aggregating data from multiple workbooks into one workbook. Due
to the way some of the data is formatted, I want to divide one of the
metrics by 100 prior to the macro pasting it into the aggregated
workbook.
How can I accomplish this?
Thanks,
Eric