I posted a thread about 4 days ago with a question similar to this, bu
only got one reply which didn't help much, so here I go again(with mor
detail this time):

this is my code right now:

With Worksheets("06").Range("A1:A275")
Set C = .Find(What:=Right("0000000" & textbox1.Value, 7)
lookat:=xlWhole)


ok, now you see how i'm only referring to one sheet ("06")? Instead
i'd like to refer to all the sheets in the workbook. Either that o
refer to a range of worksheets. I can't use the "sheets(array(sheet1
sheet2)" method because this workbooks is updated daily and I can'
refer to specific sheets unless it's a range to say "everything betwee
this sheet and that sheet" ...actually i need to refer to 3 differen
workbooks (all the same range, and all of which will already be open).

any help? :( :

--
Message posted from http://www.ExcelForum.com