Thread: Error 7
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ulf Nilsson Ulf Nilsson is offline
external usenet poster
 
Posts: 4
Default Error 7

Hi,
I want to loop through every worksheet and replace error
messages (error type 7) with 0. How is this done using
VBA?

I get error type 7 when I use VLOOKUP and the search
value is not found.

/ Ulf