| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Continue line of VBA code on the next line
I have a really long formula I am trying to set a cell value to. Is there a way to break the code up over several lines to make it more readable and help me debug? TIA! Heather. -- peacelittleone ------------------------------------------------------------------------ peacelittleone's Profile: http://www.excelforum.com/member.php...o&userid=20937 View this thread: http://www.excelforum.com/showthread...hreadid=381939 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Continue line of VBA code on the next line
Hi Peacelittleone,
the way is like this: first part of something _ second part of something _ third part of the thing Note there's a break before each _ |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Continue line of VBA code on the next line
there's a blank space before each _
(still working on my english..) |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Continue line of VBA code on the next line
If you mean formula and not VBA code, then I don't believe you can.
General approach is to put complete subelements of the formula in separate cells and get these working individually, then start combining them. -- Regards, Tom Ogilvy "peacelittleone" <peacelittleone.1r4w78_1119622311.0067@excelforu m-nospam.com wrote in message news:peacelittleone.1r4w78_1119622311.0067@excelfo rum-nospam.com... I have a really long formula I am trying to set a cell value to. Is there a way to break the code up over several lines to make it more readable and help me debug? TIA! Heather. -- peacelittleone ------------------------------------------------------------------------ peacelittleone's Profile: http://www.excelforum.com/member.php...o&userid=20937 View this thread: http://www.excelforum.com/showthread...hreadid=381939 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Continue line of VBA code on the next line
Well if you mean formula than you can do one thing:
write the formula in Notepad on as many rowd as you need and then copy it into formula bar (click into formula bar paste the formula text). This works for me in MS Excel 2000 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Continue line of VBA code on the next line
I see you did say VBA code in the subject. this just emphasizes that you
should put all the pertinent information in the body of your question to minimize misinterpretation. -- Regards, Tom Ogilvy "Tom Ogilvy" wrote in message ... If you mean formula and not VBA code, then I don't believe you can. General approach is to put complete subelements of the formula in separate cells and get these working individually, then start combining them. -- Regards, Tom Ogilvy "peacelittleone" <peacelittleone.1r4w78_1119622311.0067@excelforu m-nospam.com wrote in message news:peacelittleone.1r4w78_1119622311.0067@excelfo rum-nospam.com... I have a really long formula I am trying to set a cell value to. Is there a way to break the code up over several lines to make it more readable and help me debug? TIA! Heather. -- peacelittleone ------------------------------------------------------------------------ peacelittleone's Profile: http://www.excelforum.com/member.php...o&userid=20937 View this thread: http://www.excelforum.com/showthread...hreadid=381939 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Continue line of VBA code on the next line
Another way is that while you are typing in the information to the cell, that
if you press Alt-Enter at each point you would like to establish a break, then it will give you a new line for each Alt-Enter performed. This is what copying to the notepad is similar to, but without going to an outside utility. I think though also, that each Enter is counted as a character against the total number of characters that can be entered into the cell, so keep that in mind also. "peacelittleone" wrote: I have a really long formula I am trying to set a cell value to. Is there a way to break the code up over several lines to make it more readable and help me debug? TIA! Heather. -- peacelittleone ------------------------------------------------------------------------ peacelittleone's Profile: http://www.excelforum.com/member.php...o&userid=20937 View this thread: http://www.excelforum.com/showthread...hreadid=381939 |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Continue line of VBA code on the next line
You also might need to remove them to use the formula.
-- Regards, Tom Ogilvy "GB" wrote in message ... Another way is that while you are typing in the information to the cell, that if you press Alt-Enter at each point you would like to establish a break, then it will give you a new line for each Alt-Enter performed. This is what copying to the notepad is similar to, but without going to an outside utility. I think though also, that each Enter is counted as a character against the total number of characters that can be entered into the cell, so keep that in mind also. "peacelittleone" wrote: I have a really long formula I am trying to set a cell value to. Is there a way to break the code up over several lines to make it more readable and help me debug? TIA! Heather. -- peacelittleone ------------------------------------------------------------------------ peacelittleone's Profile: http://www.excelforum.com/member.php...o&userid=20937 View this thread: http://www.excelforum.com/showthread...hreadid=381939 |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Continue line of VBA code on the next line
I tried creating an if formula, using the alt-enter technique, and the
formula worked, I had it set up like this: =if( B1<"", "Hello", "Goodbye" ) And worked, no errors. Though it would not have worked, if I hadn't gone back and remembered to put the commas in that I was originally missing. :) "Tom Ogilvy" wrote: You also might need to remove them to use the formula. -- Regards, Tom Ogilvy "GB" wrote in message ... Another way is that while you are typing in the information to the cell, that if you press Alt-Enter at each point you would like to establish a break, then it will give you a new line for each Alt-Enter performed. This is what copying to the notepad is similar to, but without going to an outside utility. I think though also, that each Enter is counted as a character against the total number of characters that can be entered into the cell, so keep that in mind also. "peacelittleone" wrote: I have a really long formula I am trying to set a cell value to. Is there a way to break the code up over several lines to make it more readable and help me debug? TIA! Heather. -- peacelittleone ------------------------------------------------------------------------ peacelittleone's Profile: http://www.excelforum.com/member.php...o&userid=20937 View this thread: http://www.excelforum.com/showthread...hreadid=381939 |
|
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Continue line of VBA code on the next line
Obviously I tried as well and it didn't
=Sum(C2:C23) hit enter and it works select right after SUM and do Alt+Enter then exit the cell and it shows #Name error. You can let Excel correct it, but it puts in a mountain of spaces and some extra parens. Nonetheless, the OP was apparently talking about VBA code. -- Regards, Tom Ogilvy "GB" wrote in message ... I tried creating an if formula, using the alt-enter technique, and the formula worked, I had it set up like this: =if( B1<"", "Hello", "Goodbye" ) And worked, no errors. Though it would not have worked, if I hadn't gone back and remembered to put the commas in that I was originally missing. :) "Tom Ogilvy" wrote: You also might need to remove them to use the formula. -- Regards, Tom Ogilvy "GB" wrote in message ... Another way is that while you are typing in the information to the cell, that if you press Alt-Enter at each point you would like to establish a break, then it will give you a new line for each Alt-Enter performed. This is what copying to the notepad is similar to, but without going to an outside utility. I think though also, that each Enter is counted as a character against the total number of characters that can be entered into the cell, so keep that in mind also. "peacelittleone" wrote: I have a really long formula I am trying to set a cell value to. Is there a way to break the code up over several lines to make it more readable and help me debug? TIA! Heather. -- peacelittleone ------------------------------------------------------------------------ peacelittleone's Profile: http://www.excelforum.com/member.php...o&userid=20937 View this thread: http://www.excelforum.com/showthread...hreadid=381939 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro code to put series name next to individual line in line grap | Charts and Charting in Excel | |||
| How to convert a dotted line to a solid line in a line graph | Charts and Charting in Excel | |||
| How do I get the text to continue on the next line when its long | Excel Discussion (Misc queries) | |||
| Continue formula to LINE 1000 without showing FALSE | Excel Worksheet Functions | |||
| Macro problem on, Yellowed line - previous line or next line. | Excel Programming | |||
Linear Mode
