The limitation set by Microsoft Excel is 31 characters. I rewrote the function to counter that and then I did not have a situation that produced the error in question, but I would still be interested in why the error occured in this function and how to handle it. The maximum length of Excel Worksheet name is 25 characters. I found that the above function returns an earlier stop date than start date if run before the second date in the array. Excel will actually accept 409.5, but nothing bigger. ReturnDateTime := dateAdd("d", -1, cDateTime(reportdates, cTime(23,59,59))) a ridiculous number, an error message chides you by saying row height must be between 0 and 409. ReturnDateTime := cDateTime(reportdates, cTime(0,0,0)) ĭateVar stopDate = reportdates If start = true then ( // return start date Navigate to the Home tab and click on the Font Size box. Just follow these steps: Select the cell range you want to change the font size for. It's quite easy to change the font size in Excel. Find index of last reportdate not later than today However, you can change this size by adjusting the cell font size to any size between 1 and 409 points. Here is some code that sorts the array just to be sure. Any idea why and how to fix it? Function (optional BooleanVar start := true) It is kind of fun to play around with various fractional point sizes to see how Excel modifies them.The following function returns the "A subscript must be between 1 and size of array"-error when run in Crystal Reports XI. For instance, if you type 21.4, Excel increases the point size to 21.5. (This depends, of course, on the capabilities of your printer.) You can use the keyboard to enter, in the Font Size tool, any point size (or fractional point size to the nearest half point) desired. Excel allows you to specify any font size between 1 and 409 points. You are not limited to choosing a point size from those in the list, however. Click your mouse on the point size, and your text is updated. To pick a point size, simply scroll through the list and choose the one you want. If you click on the arrow to the right of this tool you are presented with a drop-down list of point sizes you can specify for the current font. In the Font group you'll notice the Font Size tool. To change the size of a font used in a selected cell or for information selected within a cell, you use the Home tab of the ribbon. A point is equal to approximately 1/72 of an inch.
Enter the number you want to set the font size to between 1 and 409 points.
The cell having a row height equal to 1 point is approximately 0. Navigate to the Home tab and click on the Font Size box. In the Home tab under the format option, you can adjust the row height or column width. Excel specifies the size of fonts in points, a unit of measurement typically used in typesetting. Just follow these steps: Select the cell range you want to change the font size for.
0 kommentar(er)
