Reference a range in another sheet

[panos45]

I have a userform where the user can input the desired worksheet to search (representing the year) and the name of a company to search and the active worksheet is a "Report" worksheet. I can't find a way to tell VBA to search that specific worksheet range... Have the following code and any help would be appreciated!

Please Login or Register  to view this content.

[TMS]

Try changing this:

Please Login or Register  to view this content.

to this:

Please Login or Register  to view this content.

[panos45]

Hi TMS, thank you for your reply, but unfortunately I get the following error on the above line "Run-time error 1004 method range of object worksheet failed"

[xlnitwit]

Perhaps this will help

Please Login or Register  to view this content.

[panos45]

Working fine! That looks easy! thank you for your help!