Hi,
I'm setting values in one spreadsheet from another using the following code:
Workbooks("Template_VBA.xlsm").Worksheets("Char").Range("E11").Value = _
Workbooks("Characteristics.xlsx").Worksheets("Active").Range("B37").Value
The original value in B37 on the "Active" worksheet is a whole number of 29.3, which I need to reflect as 29.3% in the destination worksheet ("Char"). I have a whole page of these I need to convert over into these percentages for a presentation using the below code, however, whatever I'm doing is giving me a result of 2930%.
With Range("E11")
.Value = .Value / 100
.NumberFormat = "0.0%"
End With
Anything help would be great - thank you!
I'm setting values in one spreadsheet from another using the following code:
Workbooks("Template_VBA.xlsm").Worksheets("Char").Range("E11").Value = _
Workbooks("Characteristics.xlsx").Worksheets("Active").Range("B37").Value
The original value in B37 on the "Active" worksheet is a whole number of 29.3, which I need to reflect as 29.3% in the destination worksheet ("Char"). I have a whole page of these I need to convert over into these percentages for a presentation using the below code, however, whatever I'm doing is giving me a result of 2930%.
With Range("E11")
.Value = .Value / 100
.NumberFormat = "0.0%"
End With
Anything help would be great - thank you!