| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying cell menu contents
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If Statement and copying all of cell contents. | Excel Worksheet Functions | |||
| Copying and pasting cell contents | Excel Programming | |||
| Copying cell contents between worksheets | Excel Programming | |||
| Copying Cell Contents throughout spreadsheet | Excel Programming | |||
| Copying cell contents to add to existing contents in another cell | Excel Programming | |||
Threaded Mode
