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, 02:22 PM

TileGal

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

Office 2013

Novice

Join Date: Jan 2017

Posts: 9

Run-time error '1004':
No cells were found.

Highlighting:

Code:

 Cells(rowNum, 1).EntireRow.SpecialCells(xlCellTypeConstants).ClearContents

Quote:

Originally Posted by NoSparks

Why? It would be better to fix the error or handle it differently, what is Excel telling you is wrong?

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 07:42 PM.