I am trying to add rows dynamically into a lotus spreadsheet component imbedded into a form using the following code but it does not seem to do anything. I can not see anything past the first 30 lines of the spread sheet which is how many rows I created in the form.
Call CCsheet.InsertRange(CCrow, 1, CCrow, 7, 2)
I've tried to auto size the spreadsheet using the following code before I save the document at the end but that didn't seem to do anything at all.
Row1 = -1
Col1 = 1
Row2 = CCsheet.DisplayRows
Col2 = CCsheet.DisplayCols
SetDef = True
Any help anyone could give would be appreciated. Thanks!!!
Sorry only have 30 points :(