| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert row
Hi,
Based upon some type of selection method (check box, value 1, etc) how would i get excel to insert 2 rows?? ie: cell A1 on sheet1 1, then insert 2 rows on sheet2 after a30.....any suggestions would be great!!!! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Insert row
Sub test()
If Worksheets("Sheet1").Range("A1").Value 1 Then Worksheets("Sheet2").Range("31:32").Insert xlShiftDown End If End Sub -- Rob van Gelder - http://www.vangelder.co.nz/excel "gav meredith" wrote in message ... Hi, Based upon some type of selection method (check box, value 1, etc) how would i get excel to insert 2 rows?? ie: cell A1 on sheet1 1, then insert 2 rows on sheet2 after a30.....any suggestions would be great!!!! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Insert row
Thanks Rob! Is this all i need or is there another part of the code??
"Rob van Gelder" wrote in message ... Sub test() If Worksheets("Sheet1").Range("A1").Value 1 Then Worksheets("Sheet2").Range("31:32").Insert xlShiftDown End If End Sub -- Rob van Gelder - http://www.vangelder.co.nz/excel "gav meredith" wrote in message ... Hi, Based upon some type of selection method (check box, value 1, etc) how would i get excel to insert 2 rows?? ie: cell A1 on sheet1 1, then insert 2 rows on sheet2 after a30.....any suggestions would be great!!!! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Insert row
Your request was an example for:
"cell A1 on sheet1 1, then insert 2 rows on sheet2 after a30" That's what the code I supplied does. -- Rob van Gelder - http://www.vangelder.co.nz/excel "gav meredith" wrote in message ... Thanks Rob! Is this all i need or is there another part of the code?? "Rob van Gelder" wrote in message ... Sub test() If Worksheets("Sheet1").Range("A1").Value 1 Then Worksheets("Sheet2").Range("31:32").Insert xlShiftDown End If End Sub -- Rob van Gelder - http://www.vangelder.co.nz/excel "gav meredith" wrote in message ... Hi, Based upon some type of selection method (check box, value 1, etc) how would i get excel to insert 2 rows?? ie: cell A1 on sheet1 1, then insert 2 rows on sheet2 after a30.....any suggestions would be great!!!! |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Insert row
i understand but i am a novice to VB. Do i simply need to insert this or
create a click event?? "Rob van Gelder" wrote in message ... Your request was an example for: . "cell A1 on sheet1 1, then insert 2 rows on sheet2 after a30" That's what the code I supplied does. -- Rob van Gelder - http://www.vangelder.co.nz/excel "gav meredith" wrote in message ... Thanks Rob! Is this all i need or is there another part of the code?? "Rob van Gelder" wrote in message ... Sub test() If Worksheets("Sheet1").Range("A1").Value 1 Then Worksheets("Sheet2").Range("31:32").Insert xlShiftDown End If End Sub -- Rob van Gelder - http://www.vangelder.co.nz/excel "gav meredith" wrote in message ... Hi, Based upon some type of selection method (check box, value 1, etc) how would i get excel to insert 2 rows?? ie: cell A1 on sheet1 1, then insert 2 rows on sheet2 after a30.....any suggestions would be great!!!! |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Insert row
Code is triggered to run. How that's triggered depends on what you need it
for. For example, if you wanted that code to run whenever a button is clicked: From Visual Basic: Insert Module - insert the code into the module From Excel: Ensure the Form toolbar is visible (View | Toolbars | Forms) Drop a Button onto your worksheet (an 'assign macro' window appears) Assign the macro -- Rob van Gelder - http://www.vangelder.co.nz/excel "gav meredith" wrote in message ... i understand but i am a novice to VB. Do i simply need to insert this or create a click event?? "Rob van Gelder" wrote in message ... Your request was an example for: . "cell A1 on sheet1 1, then insert 2 rows on sheet2 after a30" That's what the code I supplied does. -- Rob van Gelder - http://www.vangelder.co.nz/excel "gav meredith" wrote in message ... Thanks Rob! Is this all i need or is there another part of the code?? "Rob van Gelder" wrote in message ... Sub test() If Worksheets("Sheet1").Range("A1").Value 1 Then Worksheets("Sheet2").Range("31:32").Insert xlShiftDown End If End Sub -- Rob van Gelder - http://www.vangelder.co.nz/excel "gav meredith" wrote in message ... Hi, Based upon some type of selection method (check box, value 1, etc) how would i get excel to insert 2 rows?? ie: cell A1 on sheet1 1, then insert 2 rows on sheet2 after a30.....any suggestions would be great!!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cannot insert worksheet in exel - not available in insert menu | Excel Worksheet Functions | |||
| insert row / insert column command buttons | Excel Worksheet Functions | |||
| How can I insert a date with an icon (calendar) insert | Excel Discussion (Misc queries) | |||
| Can I auto insert a worksheet when I insert a value in a cell. | Excel Worksheet Functions | |||
| Insert Next? Or insert a variable number of records...how? | Excel Discussion (Misc queries) | |||
Hybrid Mode
