| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding drawing to index, need to shift everything down
I am putting together a program to search a Powerplants drawings and
need a function to add a new drawing should they create one. I hav everything needed to find the place in the index where the drawin should go, but I can't figure out how to "shift" everything (10 columns wide) down by one cell so that I can insert the new drawing. I thought this would work range(activecell,cells(100,2000)).Select but it gives me a runtime 1004 error any ideas -- Message posted from http://www.ExcelForum.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding OR to an index match formula | Excel Worksheet Functions | |||
| adding AND, OR to excisting INDEX formula | Excel Discussion (Misc queries) | |||
| Adding rows to the data array used in an Index function | Excel Discussion (Misc queries) | |||
| Incorporating INDEX function into Array Formula (CNTRL-SHIFT-ENTER | Excel Worksheet Functions | |||
| Adding or pasting a row, but having info shift upwards not down?? | Excel Worksheet Functions | |||
Linear Mode
