Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-29-2017, 02:22 PM
TileGal TileGal is offline Insert Row with Command Button Include Formulas and Merged Cells Windows 7 64bit Insert Row with Command Button Include Formulas and Merged Cells Office 2013
Novice
Insert Row with Command Button Include Formulas and Merged Cells
 
Join Date: Jan 2017
Posts: 9
TileGal is on a distinguished road
Default


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

Highlighting:
Code:
 Cells(rowNum, 1).EntireRow.SpecialCells(xlCellTypeConstants).ClearContents


Quote:
Originally Posted by NoSparks View Post
Why? It would be better to fix the error or handle it differently, what is Excel telling you is wrong?
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert Row with Command Button Include Formulas and Merged Cells 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
Insert Row with Command Button Include Formulas and Merged Cells 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
Insert Row with Command Button Include Formulas and Merged Cells 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 01:09 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft