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

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