Insert Row with Command Button Include Formulas and Merged Cells

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Insert Row with Command Button Include Formulas and Merged Cells

08-29-2017, 10:19 AM

NoSparks

Windows 7 64bit Insert Row with Command Button Include Formulas and Merged Cells

Office 2010 64bit

Excel Hobbyist

Join Date: Nov 2013

Location: British Columbia, Canada

Posts: 842

Add a second paste line

Code:

Rows(rowNum).PasteSpecial Paste:=xlFormats

You might also want to add

Code:

If rowNum = 0 Then Exit Sub

right after the InputBox.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Cannot get macro button to sort with merged cells on sheet	lonniepoet	Excel Programming	3	02-04-2016 04:33 PM
Create a command button that will insert another drop down menu	Tinamation	Word VBA	1	11-06-2015 03:11 PM
Table will not allow sorting because "cells are merged". I can't find the merged cells.	wendyloooo	Word Tables	1	05-26-2015 01:19 PM
Accidentally merged cells?	Fraser	Excel	2	02-16-2014 10:15 PM
Command Button	cksm4	Word VBA	7	02-27-2011 08:47 PM

Other Forums: Access Forums

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