View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Assign Formula to Variable

James,

Try this

Length = Len(FileNumber4)


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"James Stephens" wrote in message
...
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