| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Autofill knowing row and column number
I want to do the programmatic equivalent of dragging the fill handle down
one row. I know the row and column number of the destination cell. I tried: ..cells(Nextrow - 1, 2).autofill destination=.cells(Nextrow, 2) but I got a range error. What's the correct syntax? Also, what's the syntax if I want to fill a range of cells (eg, columns 12 to17)? -- Thanks, Fred |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Autofill column from data (code) in column next to it | Excel Worksheet Functions | |||
| Knowing the number | Excel Discussion (Misc queries) | |||
| Automating to autofill column B based on column A entry | Excel Discussion (Misc queries) | |||
| Autofill Column D based on input in Column C | Excel Discussion (Misc queries) | |||
| Number of different items in an entire column without knowing if some of the cells are blank | Excel Programming | |||
Threaded Mode
