I'm populating a spreadsheet from a template using Access VBA. A cell
in row 3 contains a pulldown static menu of selection items. I need
to copy these cell menu options to each new row of data copied to the
spreadsheet.

If I use wks.Cells(iRow, 22) = wks.Cells(3, 22) then only the cell
contents (not the menu options) get copied.

If I use wks.Cells(iRow, 22).Formula = wks.Cells(3, 22).Formula then
nothing get copied.

Thanks for your help!

Kevin