Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
force line break in excel cell
Name: kgarvin Date: November 24, 2004 at 05:39:03 Pacific OS: Windows XP CPU/Ram: bbb
Comment:
I am attempting to force a line break within a cell while generating an excel worksheet from vb code (SalesLogix' version of it). Vbcrlf, Chr(0010), Chr(10), Chr(10) & Chr(13), etc. all push the subsequent text to the next row instead of adding a line break within the cell. What I think I need is the ascii code for the key combination alt+0010 , or alt+enter. I have been looking for this without success.. Any ideas?
Summary: I have set up a simple timecard in Excel. There is a time field for clocking in, and another for clocking out. I want Excel to then calculate the number of hours worked. I have used the advise on this...
Summary: I am trying to code a carriage return within an excel cell using vbscript. When I append chr(10) or Chr(10) & Chr(13) to the string that is being written in the cell, it begins a new row in the excel...
Summary: It's easy to do for single quotes.... In Excel, highlight your range of cells. Click Format (on the menu bar) then Cells. Then click "Custom" under the category list box. In the textbox under "Type"...