View Single Post
 
Old 08-29-2017, 02:22 PM
TileGal TileGal is offline Windows 7 64bit Office 2013
Novice
 
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