Thread: Creating a formula in VBA with quoted strings
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] tkpmep@hotmail.com is offline
external usenet poster
  
Posts: 16
Default Creating a formula in VBA with quoted strings
Figured it out by trying out stuff from other posts in this group:


Cells(BottomRow, 6).Formula = "=text(" & Mid(Trim(Cells(BottomRow, 6).Formula), 2) & ", ""0.00%"" )" & " & " & Chr(34) & " / " & Chr(34) & " & text(" & x & ", ""0.00%"" )"

where x is a real number.


Reply With QuoteReply With Quote