For the table and cell references how do you determine which cell to assign the code to?
With .Tables(lTbl).Cell(lRow, 1).Range.FormFields(1)
Set Rng = .Tables(2).Cell(lRow, 2).Range
.Tables(2) is the second table, correct?
I'm using a cell ref macro that shows the output cell as column 2 row 3.
The dropdown being in Column 1 row 3
I'm trying to use this macro for other items in the form. I'm guessing part of the problem is the cell references get all screwed up in merged cells. Does that make it impossible or just difficult?
|