Format Returned Values in VBA Q

  • Thread starter Thread starter Seanie
  • Start date Start date
S

Seanie

The code below returns for me the values in Cells E6 & B62, but the
value in B62 is 18.87% but what is returned for me on my code is
0.1847547857. How can I format what is returned as **.**%?


ThisWorkbook.Sheets("Master").Range("E6") & " " & ThisWorkbook.Sheets
("Report").Range("B62") & vbNewLine & _
 
When you use Range(xx) without specifying a property, the Value property is
assumed. Try using the Text property instead...

ThisWorkbook.Sheets("Master").Range("E6").Text & " " & ThisWorkbook.Sheets
("Report").Range("B62") & vbNewLine & _
 
Back
Top