Assign Formula to Variable

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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 said:
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
Click to expand...
characters in the variable named "FileNumber4"
Where am I going wrong, I have looked around and I though this should work
Click to expand...
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.
 
Everything enclosed within a pair of double quotes is considered a
literal. So, you are getting the length of the literal string space-
ampersand-space-the-letters-that-spell-FileNumber4-space-ampersand-
space.

To get the length of the contents of FileNumber4 use Len(FileNumber4)

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Thanks guys, that took care of it. Sometimes its so simple you just can't figure it out

Thanks alot for the help

Ji

----- Tushar Mehta wrote: ----

Everything enclosed within a pair of double quotes is considered a
literal. So, you are getting the length of the literal string space
ampersand-space-the-letters-that-spell-FileNumber4-space-ampersand
space

To get the length of the contents of FileNumber4 use Len(FileNumber4

--
Regards

Tushar Meht
www.tushar-mehta.co
Excel, PowerPoint, and VBA add-ins, tutorial
Custom MS Office productivity solution
 
Back
Top