View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
James Stephens James Stephens is offline
external usenet poster
 
Posts: 26
Default Assign Formula to Variable

I am sure this is simple but I can't figure our where I am going wrong, here is what I have

Length = Len(" & FileNumber4 & "

I am trying to assign to the variable named "Length" the number of characters in the variable named "FileNumber4

Where am I going wrong, I have looked around and I though this should work but the value for Length should end up as either a 5 or a 6 and it is telling me it is 17. I am a little lost

Thanks for the advice

Jim