View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Doug Doug is offline
external usenet poster
 
Posts: 460
Default FROM and TO Cell References in VBA

This: =TEXT($L2,"""from"" 0.0""%"";"""" 0.0""%"";""""")&" to
"&TEXT($M2,"0.0%")&","

yields this: from 84.8% to 8451.0%,

I need to have it say: from 84.8% to 84.5%, .

(So, what is the proper way to join parts of a VBA statement together,
anyway)?

Please advise.
DOUG ECKERT