Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Footers in which number of characters exceeds 255
The legal types are making me put in footnotes into my spreadsheets which
exceed 255 characters. First one they sent down had 428 characters in it. So I can't put it in a cell or in a custom footer. Please note: I'm running the official version approved by the company - Excel 97. I was thinking I could somehow plant a text box to hold the text. The text will have variables in it. So I was going to use VBA to fill the box with the calculated text. But I'm having some diffculty with it as it is not on a form. Do I have any other options? Would a more recent or current version of Excel provide any solution? -- DRK |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Footers in which number of characters exceeds 255
A cell can display at least 1024 characters and more if you hard code
returns in the string. So a cell should be able to handle 428 characters. This includes xl97. In xl97, the limitation on a cell was increased to 32K characters - although only 1024 will display or print (unless you embed hard returns) -- Regards, Tom Ogilvy "DRK" wrote in message ... The legal types are making me put in footnotes into my spreadsheets which exceed 255 characters. First one they sent down had 428 characters in it. So I can't put it in a cell or in a custom footer. Please note: I'm running the official version approved by the company - Excel 97. I was thinking I could somehow plant a text box to hold the text. The text will have variables in it. So I was going to use VBA to fill the box with the calculated text. But I'm having some diffculty with it as it is not on a form. Do I have any other options? Would a more recent or current version of Excel provide any solution? -- DRK |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Footers in which number of characters exceeds 255
Thanks for the help. With your guidance I can put in more than the 255
characters. But it does not seem to carry over to the .CenterFooter for example. Using the same code generated string, I can fill a cell with text but the .CenterFooter can't be fooled. I get a Run-time error '1004' with the message 'Unable to set the CenterFooter property of the PageSetup class'. So I may punt and hope the lawyers will allow me to add a separate footnote page after the column report. -- DRK "Tom Ogilvy" wrote: A cell can display at least 1024 characters and more if you hard code returns in the string. So a cell should be able to handle 428 characters. This includes xl97. In xl97, the limitation on a cell was increased to 32K characters - although only 1024 will display or print (unless you embed hard returns) -- Regards, Tom Ogilvy "DRK" wrote in message ... The legal types are making me put in footnotes into my spreadsheets which exceed 255 characters. First one they sent down had 428 characters in it. So I can't put it in a cell or in a custom footer. Please note: I'm running the official version approved by the company - Excel 97. I was thinking I could somehow plant a text box to hold the text. The text will have variables in it. So I was going to use VBA to fill the box with the calculated text. But I'm having some diffculty with it as it is not on a form. Do I have any other options? Would a more recent or current version of Excel provide any solution? -- DRK |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Footers in which number of characters exceeds 255
Sorry, I didn't say or mean to imply that the footers could hold more
characters. I thought you were considering putting the information in a cell that would appear at the bottom of the printed page (all calculated/setup manually) as a workaround for the footer limitation. -- Regards, Tom Ogilvy "DRK" wrote in message ... Thanks for the help. With your guidance I can put in more than the 255 characters. But it does not seem to carry over to the .CenterFooter for example. Using the same code generated string, I can fill a cell with text but the .CenterFooter can't be fooled. I get a Run-time error '1004' with the message 'Unable to set the CenterFooter property of the PageSetup class'. So I may punt and hope the lawyers will allow me to add a separate footnote page after the column report. -- DRK "Tom Ogilvy" wrote: A cell can display at least 1024 characters and more if you hard code returns in the string. So a cell should be able to handle 428 characters. This includes xl97. In xl97, the limitation on a cell was increased to 32K characters - although only 1024 will display or print (unless you embed hard returns) -- Regards, Tom Ogilvy "DRK" wrote in message ... The legal types are making me put in footnotes into my spreadsheets which exceed 255 characters. First one they sent down had 428 characters in it. So I can't put it in a cell or in a custom footer. Please note: I'm running the official version approved by the company - Excel 97. I was thinking I could somehow plant a text box to hold the text. The text will have variables in it. So I was going to use VBA to fill the box with the calculated text. But I'm having some diffculty with it as it is not on a form. Do I have any other options? Would a more recent or current version of Excel provide any solution? -- DRK |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Footers in which number of characters exceeds 255
Tom,
Thanks for reminding me that I can print multiple ranges on each page. I'm trying to figure out why the second range appears on the next page rather than on the same page. I made to clean out any page breaks from the sheet. I specified the range in the macro as "$A$13:$G42,$A$120:$G$121" Don "Tom Ogilvy" wrote in message ... Sorry, I didn't say or mean to imply that the footers could hold more characters. I thought you were considering putting the information in a cell that would appear at the bottom of the printed page (all calculated/setup manually) as a workaround for the footer limitation. -- Regards, Tom Ogilvy "DRK" wrote in message ... Thanks for the help. With your guidance I can put in more than the 255 characters. But it does not seem to carry over to the .CenterFooter for example. Using the same code generated string, I can fill a cell with text but the .CenterFooter can't be fooled. I get a Run-time error '1004' with the message 'Unable to set the CenterFooter property of the PageSetup class'. So I may punt and hope the lawyers will allow me to add a separate footnote page after the column report. -- DRK "Tom Ogilvy" wrote: A cell can display at least 1024 characters and more if you hard code returns in the string. So a cell should be able to handle 428 characters. This includes xl97. In xl97, the limitation on a cell was increased to 32K characters - although only 1024 will display or print (unless you embed hard returns) -- Regards, Tom Ogilvy "DRK" wrote in message ... The legal types are making me put in footnotes into my spreadsheets which exceed 255 characters. First one they sent down had 428 characters in it. So I can't put it in a cell or in a custom footer. Please note: I'm running the official version approved by the company - Excel 97. I was thinking I could somehow plant a text box to hold the text. The text will have variables in it. So I was going to use VBA to fill the box with the calculated text. But I'm having some diffculty with it as it is not on a form. Do I have any other options? Would a more recent or current version of Excel provide any solution? -- DRK |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Footers in which number of characters exceeds 255
If I reminded you of that fact, that wasn't my intent either. You can't
print multiple non contiguous ranges on the same page. Each area will go on a separate page. What you can do is hide rows/columns in between, then print one large range. another possibility is to copy the ranges and paste them as linked pictures to another page, then arrange the pictures to achieve your layout and print that page. There may be other clever workarounds as well based on the particulars of your problem which I am not privy to. -- Regards, Tom Ogilvy "Don Kline" wrote in message ... Tom, Thanks for reminding me that I can print multiple ranges on each page. I'm trying to figure out why the second range appears on the next page rather than on the same page. I made to clean out any page breaks from the sheet. I specified the range in the macro as "$A$13:$G42,$A$120:$G$121" Don "Tom Ogilvy" wrote in message ... Sorry, I didn't say or mean to imply that the footers could hold more characters. I thought you were considering putting the information in a cell that would appear at the bottom of the printed page (all calculated/setup manually) as a workaround for the footer limitation. -- Regards, Tom Ogilvy "DRK" wrote in message ... Thanks for the help. With your guidance I can put in more than the 255 characters. But it does not seem to carry over to the .CenterFooter for example. Using the same code generated string, I can fill a cell with text but the .CenterFooter can't be fooled. I get a Run-time error '1004' with the message 'Unable to set the CenterFooter property of the PageSetup class'. So I may punt and hope the lawyers will allow me to add a separate footnote page after the column report. -- DRK "Tom Ogilvy" wrote: A cell can display at least 1024 characters and more if you hard code returns in the string. So a cell should be able to handle 428 characters. This includes xl97. In xl97, the limitation on a cell was increased to 32K characters - although only 1024 will display or print (unless you embed hard returns) -- Regards, Tom Ogilvy "DRK" wrote in message ... The legal types are making me put in footnotes into my spreadsheets which exceed 255 characters. First one they sent down had 428 characters in it. So I can't put it in a cell or in a custom footer. Please note: I'm running the official version approved by the company - Excel 97. I was thinking I could somehow plant a text box to hold the text. The text will have variables in it. So I was going to use VBA to fill the box with the calculated text. But I'm having some diffculty with it as it is not on a form. Do I have any other options? Would a more recent or current version of Excel provide any solution? -- DRK |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
text exceeds allowed number of characters per cell | Excel Worksheet Functions | |||
counting if a value exceeds a specified number | Excel Discussion (Misc queries) | |||
Calculating a formula that exceeds 1,000 characters | Excel Worksheet Functions | |||
Locate first number that exceeds reference value | Excel Worksheet Functions | |||
Delete A Word That Exceeds X Number Of Characters | Excel Worksheet Functions |