Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am unable to handle a ceratin error that crops up when
the following code is run. Sub compare() Application.ScreenUpdating = False Dim cell As Range For Each cell in Sheets("Sheet2").Range("A2:A501") Range("E6:E" & Range("E65536").End(xlUp).Row).Find (cell.Value).Activate 'do stuff if cell.value found Next cell Application.ScreenUpdating = True End Sub My problem occurs when a value on sheet2 is not found in column E on sheet1. I need an error handler to skip the part that does stuff and starts again at Next cell. Thanks in advance. Gareth |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Handling #NUM! error | Excel Worksheet Functions | |||
Error Handling | Excel Programming | |||
Error Handling | Excel Programming | |||
Error handling | Excel Programming | |||
Error handling | Excel Programming |