Hello,

I have data from a database and inserting it into Excel. Then I adjust the properties like this:

Code:
        With xlsApp.Selection
            'Position and size of the textbox
            .Left = xlsSheet.Cells(cPVCRRowFirstPts + lngNbPts + 4, 3).Left + 3
            .Top = xlsSheet.Cells(cPVCRRowFirstPts + lngNbPts + 4, 1).Top
            .Width = 420#
            .Height = 114.75
            .Font.Size = 11
        End With
I would like the height of the cell to be dynamic depending on the contents of the cell. Anybody know how to do this?