Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am using Windows XP with Office 2003.
I have a VBA program in which I can enter a header or footer string in a sheet and the program enters this string for me into the header or footer of hundreds of files that are formatted automatically. For example a set up string might look like: &"Arial,Bold"&10&UACCOUNT SUMMARY CONTINUED: The above would be "Arial", bold, 10-points, underlined. This works great. The only thing is, I need to be able to insert a return or a line feed at the beginning and/or end of the string and I can't seem to get it to work. For example, I tried variations of the following without success: &Chr(10) &"Arial,Bold"&10&UACCOUNT SUMMARY CONTINUED: &"Chr(13)" &"Arial,Bold"&10&UACCOUNT SUMMARY CONTINUED: Could someone PLEASE help me out on this and post back a correction to make it work? Thanks so much in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Challenge - Excel Line Feed Character CHR(10) - How to Delete and keep the text formatting without going ro single line in a cell ? | Excel Worksheet Functions | |||
header and footer boarder line | New Users to Excel | |||
Replace Line Feed | Excel Discussion (Misc queries) | |||
Line Feed | Excel Programming | |||
how does excel store new line and line feed characters? | Excel Programming |