I’m working on automation with word. Had no problems but to do the same in Excel I need to use Nothing and Set. Any idea’s? Set rng = Nothing ... ... If Not rng Is Nothing Then rng.Delete End If
What exactly are you trying to accomplish with Set and Nothing? If all you need to do is marking a range as not to be deleted by setting it to Nothing, you could just as well use an ordinary Boolean variable to hold this information…
http://www.mbsonline.org/forum/topic.asp?TOPIC_ID=4806&SearchTerms=on+error here the same problem, the result of the find can give you “Nothing”.