VBA, search and return a message

"what is UBound(Arr)?"

It use in a loop. 0 to Ubound (highest available subscript for the indicated dimension of an array) which will be 1 as only two items e.g 0 and 1


http://msdn.microsoft.com/en-us/libr...2f(VS.80).aspx

"what is After:=?"

The dot tells you it relates to Sheet Info. Then the rest is Row 1 of Col A eg Cell A1 in Sheets info

:=.Cells(1, "A"),

"i am not sure what this means"

This statement says if it the Rng isn't empty then

If Not Rng Is Nothing Then

HTH

VBA Noob

Arr = Array("N o r m a l    t e r m i n a t i o n", "E r r o r   t e r m i n a t i o n")

The i statement loops throught the two conditions above (0 = Normal and 1= Error). If it finds both it will accept the last one.

If none found I would use the Else statement for that.

As you are finding out you need to spend more time thinking about all the options before posting a question

VBA Noob