View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
groupie groupie is offline
external usenet poster
 
Posts: 12
Default Final space removed when moving to Object variable

Is there a solution to this problem? The final space in a String is
deleted when assigned to a field in an Object variable.


Dim obHead As Object
Dim strLet As String

strLet = "ABCD " 'ABCD and a final space

obHead.Value("OBJ") = strLet "obHead.Value("OBJ") contains ABCD
(no space)


Thanks for any assistance!