find value within range

[calvi]

I cannot find an existing value within the range.
example: worksheet.Range(Cells(1, 1), Cells(50, 1)).Find(What:=7)
Within my range there are few ranges with mergearea. 7 is for example at cell (17,1). But with this code the result is nothing. Isn't it possible to find within several mergearea? Is there another solution?

 

[Remou]

This is an Access forum, you will find some good Excel people in forum707.