Hi,

I need some code which will find a value in a workbook.
The value will only appear once in the workbook but i wont know what sheet the value will be in.

On the attached workbook there is a simpified version.

In this example i would need to find the value in A1 in sheet a, this would be on worksheet b.

I need to scale this up though, any ideas?

Cheers,
Tom.Test Sheet.xlsm