Thread
:
To Check Errors for a range of cells
View Single Post
#
1
Posted to microsoft.public.excel.programming
AccessHelp
external usenet poster
Posts: 213
To Check Errors for a range of cells
Hi,
I want to write a code to check whether errors exist in column E. I use the
following code:
Dim r as Interger
r=9
r=r+1
If iserror(cells(r,5)) then
Msgbox "Please fix error"
else
Thanks. Please help.
Reply With Quote
AccessHelp
View Public Profile
Find all posts by AccessHelp