I am looking to create a string and maintain certain formattting w/in the string. Is what I am trying to do legal, if so, where is my error here?
[VBA]
Range("J11").Value = WorksheetFunction.Proper(company & Chr(32) & season & Chr(32) & year) And _
UCase(store & Chr(32) & Format(Date, "m-dd-yy"))
[/VBA]
thx
my site: www.ecboardco.com
was built w/ a majority of the assistance from the board members here... thanks VBAX.
Just because I see something, doesn't mean that what's actually happening is what I see.
You don't get from 0-90 by standing still!
Doug,
Use & not And.
And is a logical opeartor, & is a text concatenator.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Thanks Bob,
needed to know the difference between the two.
my site: www.ecboardco.com
was built w/ a majority of the assistance from the board members here... thanks VBAX.
Just because I see something, doesn't mean that what's actually happening is what I see.
You don't get from 0-90 by standing still!
Posting Permissions
Reply With Quote
