| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drag/fill colums and Delete Columns
I know I can drag/fill and delte a colum range as follows below from a
recorded macro. How do I use column numbers in VBA to replicate these acts? Assume ahead of time I know for the drag/fill I kno my range is C2:C17. Also assume that for the delete I know the starting range of C19:J32. Thanks 'Drag and fill Range("C2:C17").Select Selection.AutoFill Destination:=Range("C2:J17"), Type:=xlFillDefault Range("C2:J17").Select 'Delete Range Range("C19:J32").Select Range("J19").Activate Selection.ClearContents |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I drag and fill hyperlinks? | Excel Worksheet Functions | |||
| Fill & Drag to Right !! HELP ! | Excel Discussion (Misc queries) | |||
| Why is my drag and fill not following the pattern? | Excel Worksheet Functions | |||
| Drag down the color fill box | Excel Discussion (Misc queries) | |||
| Drag and fill from other sheets | Excel Discussion (Misc queries) | |||
Threaded Mode
