Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Insert Row with Command Button Include Formulas and Merged Cells
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 08-29-2017, 02:20 PM
NoSparks NoSparks 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 2010 64bit
Excel Hobbyist
  
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default

Quote:
I only had to UNCOMMENT the error code.
Why? It would be better to fix the error or handle it differently, what is Excel telling you is wrong?
Reply With Quote
  #2  
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

« Previous Thread | Next Thread »


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 03:18 PM.

Contact Us - Privacy Statement - Top

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