I am using the following formula in a macro, but it is all on one line, thus making it difficult to view. I am not sure what I am doing wrong. Being a beginner, I am likely overlooking some basic rules of thumb.
Please help with the following:
Please Login or Register to view this content.
Last edited by Wedge120; 09-06-2010 at 11:44 PM. Reason: solved
Try a Space Underscore and then Enter to start a continuation of a line.
That will allow you to wrap.
I've been trying that, but I get errors . I believe there are certain places where this can be applied successfully, but not at all locations within the formula. I believe there are rules to follow, but I do not know what they are.
provide a few more lines of your code so the formula can be seen in its context, please.
OK - I thought you were in the VBA editor and I guess you aren't.
If you are looking at the formula bar just after Fx then put your mouse on the bar between the column letters and the function input and click and drag it down. Let me know if that was it.
Marvin, the way I read it it is indeed in the VBE, hence my request for the surrounding lines of code.
Please Login or Register to view this content.
Hello again, since the formula that you are entering is in effect a text string, you can put the break anywhere, but you must close the string with " and then add the space and underscore. On the next row, use a & and an opening " to continue the string.
for example like this
Please Login or Register to view this content.
That worked. Thank you very much. Marking as 'SOLVED'.
So these rules apply to any given text string?
Hey teylyn -
You read it right, but without seeing that s/he was really in the VBE, I couldn't tell. I was think they might have been in the formula bar. You saw that(264/6949 (I'll get better))
Last edited by MarvinP; 09-06-2010 at 11:46 PM.
Yes, they apply to all text strings. You can't break a text string to the next row just with a _ as far as I know.
MarvinP,???????????(264/6949
If you want to use line continuation with a string you also need the concatenation operator &.
Something like this perhaps.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks