| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Formatting with VBA
I am creating an Excel spreadsheet through code from MS Access. After
it is created I would like to go through and set the row height (programtically) based on the value in column A. I'm not sure how to go about moving through each row and setting this attribute. TIA Bill |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Formatting with VBA
Hi Bill
Looping rows can be done like this Dim L As Long For L = 1 To 100 Rows(L).RowHeight = 5 Next HTH. Best wishes Harald "Bill Short" skrev i melding om... I am creating an Excel spreadsheet through code from MS Access. After it is created I would like to go through and set the row height (programtically) based on the value in column A. I'm not sure how to go about moving through each row and setting this attribute. TIA Bill |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting lost when saving excel 2003 file using excel 2007 | Excel Discussion (Misc queries) | |||
| "Excel encountered an error and had to remove some formatting toavoid corrupting the workbook. Please re-check your formatting carefully." | Excel Discussion (Misc queries) | |||
| Saving Excel 2007 conditional formatting in Excel 2003 format | Excel Discussion (Misc queries) | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| expanding custom formatting without removing existing cell formatting? | Excel Worksheet Functions | |||
Linear Mode
