| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can excel insert rown based on variable data in a cell?
will insert 4 rows at row 14 if 4 in cell b1
Rows("14:" & 14 + Range("b1") - 1).Insert -- Don Guillett SalesAid Software "SSBG" wrote in message ... I'm trying to create a spreadsheet where a value in a particular cell will be changing. The question i have is, can excel read the data from that cell and insert rows after a certain designated row based on that variable value? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Variable SQL Statements pulling from a cell in Excel | Excel Worksheet Functions | |||
| need excel to look for the 4th digit in a cell then insert new num | Excel Discussion (Misc queries) | |||
| Can I copy a table from Word into one cell in Excel without losing data? (Office 97) | Excel Discussion (Misc queries) | |||
| Excel 2003, Convert EXISTING Worksheet Data to XML? | Excel Discussion (Misc queries) | |||
| Input cell reference is not valid (One Variable Data Table) | Excel Worksheet Functions | |||
Hybrid Mode
