Add a button to add a line

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Add a button to add a line

04-15-2019, 10:25 AM

Logit

Windows 10 Add a button to add a line

Office 2007

Expert

Join Date: Jan 2017

Posts: 591

Code:

Sub insertrows()
    ActiveCell.EntireRow.Offset(1).Resize(1).Insert Shift:=xlDown
End Sub

The above will add a blank line below the cell that is selected.

If you click on A7, then run the above macro, the new line will be added
on A8.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to create a "Font color" button and a "Highlight text" button in the Quick Launch toolbar ?	gloub	Word	12	02-19-2019 03:19 PM
Usability of space between final line of body text and footnote separator line	Swarup	Word	6	07-28-2018 12:51 PM
How to change the default features for AutoShape horizontal line (button 'Insert horizontal line')	534tomasz	Word	6	10-13-2016 02:33 AM
how can I cut and paste a line in page1 to page 2 by clicking a button?	esco	Excel	11	12-10-2013 10:48 AM
How to run two button macros with one button?	Geza59	Excel Programming	1	02-14-2013 12:11 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:10 AM.