MSGROUPS.NET | Search | Post Question | Groups | Stream | About | Register

Create a button to insert a new row.

  • Follow


I know Excel can do it; I just don't know how.  In addition, once the new row 
is inserted, I need the formulas to carry into it.

Any help is greatly appreciated!
0
Reply Utf 1/6/2010 6:01:04 PM 

I can think of many possibilities, but I'm sure you are thinking of something 
very specific.  Please give more information.

-- 
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Sharon" wrote:

> I know Excel can do it; I just don't know how.  In addition, once the new row 
> is inserted, I need the formulas to carry into it.
> 
> Any help is greatly appreciated!
-1
Reply Utf 1/6/2010 6:29:01 PM 


Assuming you want the inserted row at the cursor location:
Sub InsertIt()
   On Error Resume Next
   Rows(Activecell.Row).Insert
   Rows(Activecell.Row-1).Resize(2).FillDown
   Rows(Activecell.Row).specialcells(xlcelltypeconstants).clearcontents
End Sub

"Sharon" <Sharon@discussions.microsoft.com> wrote in message 
news:497865B1-0DDB-48BB-9813-77A77890AAA2@microsoft.com...
> I know Excel can do it; I just don't know how.  In addition, once the new 
> row
> is inserted, I need the formulas to carry into it.
>
> Any help is greatly appreciated!
0
Reply Bob 1/6/2010 6:35:34 PM
microsoft.public.excel.worksheet.functions 4936 articles. 39 followers.

2 Replies
1478 Views

(page loaded in 0.047 seconds)

Similiar Articles:

Create a button to insert a new row. - microsoft.public.excel ...
I know Excel can do it; I just don't know how. In addition, once the new row is inserted, I need the formulas to carry into it. Any help is grea...

Button on Form to Add more rows - microsoft.public.excel.worksheet ...
Create a button to insert a new row. - microsoft.public.excel ... Button on Form to Add more rows - microsoft.public.excel.worksheet ... Create a button to insert a new ...

How can I insert rows BELOW, in Excel - microsoft.public.excel ...
Create a button to insert a new row. - microsoft.public.excel ... How can I create a VBA script to insert row ("add button") in Excel? ... macros prompt the user for a row ...

How to insert a row in a table in Excel? - microsoft.public.word ...
Create a button to insert a new row. - microsoft.public.excel ... Excel 2007 User form Enter Data Last Row @Table - microsoft.public ... Whenever I insert a new row ...

Script to insert Row - microsoft.public.excel.misc
Create a button to insert a new row. - microsoft.public.excel ... Script to insert Row - microsoft.public.excel.misc Script to insert Row - microsoft.public.excel.misc How ...

Can't insert row in data table in protected worksheet ...
Whenever I insert a new row ... data in table ... Spreadsheet Can anyone tell ... Macro Button To Create New Line? Create New Worksheets From Button/link; Insert Row On ...

excel macro/funcion insert row if - microsoft.public.excel.misc ...
Create a button to insert a new row. - microsoft.public.excel ... microsoft.public.excel ... VBA script to insert row ("add button") in Excel? ... macros ...

Macro to take to last line and insert new row with number ...
Create a button to insert a new row. - microsoft.public.excel ..... number in A ... button to insert a new row ... Last Row @Table - microsoft.public ...

How to insert row after data from user form - microsoft.public ...
Create a button to insert a new row. - microsoft.public.excel ... Excel 2007 User form Enter Data Last Row @Table - microsoft.public ... Whenever I insert a new row ...

How to make a table row into a header row? - microsoft.public.word ...
Create a button to insert a new row. - microsoft.public.excel ... Excel 2007 User form Enter Data Last Row @Table - microsoft.public ... ... Macro to Insert Rows Into a ...

Excel :: Create An "Insert Row" Button In An Excel Spreadsheet
Create New Worksheets From Button/link; Insert Row On Sheet & Move Active Cell Row To It; Create The Dropdown Box And Insert The Text; Macro - Auto Insert And Create A Worksheet

How can I create a VBA script to insert row ("add button") in ...
How can I create a VBA script to insert row ("add button") in Excel? ... for, but these macros prompt the user for a row above/below which a new row is ...

Create a button to insert a new row. - microsoft.public.excel ...
I know Excel can do it; I just don't know how. In addition, once the new row is inserted, I need the formulas to carry into it. Any help is grea...

How to Add New Rows to Gridview | eHow.com
Create the new row in GridView and add the label to the first column. Type the ... It uses properties of the cells, rows... How to Add an Edit Button to DataGrid

How to Create a Macro to Insert Rows Into a Spreadsheet | eHow.com
How to Create a Macro to Insert Rows Into a Spreadsheet. ... Choose where you wish to store the new macro from the ... you open Excel, click on the "Microsoft Office" button ...

7/24/2012 12:39:42 PM


Reply:



Privacy Policy | All Times Are GMT(UTC) | powered by