Selecting a worksheet column from a different worksheet module?

I have a worksheet module macro triggered by clicking a hyperlink that needs to select a column on a different work sheet to find the first instance of a word in column A. What is the syntax to select a column of a different worksheet from a worksheet module? Here is an example of my code that works when the second line is commented out and fails (Run-time 1004 error) when it’s not.

Please Login or Register  to view this content.

I could move this to a general module to make it work, but I suspect this is a syntax issue I’d like to understand and I’m curious.
My goal is to search for a specific word in column A and when I find the first instance, scroll the worksheet up so that line is on the top of the page. I appreciate any suggestions.

Well, that’s embarrassing. The first thing I tried was fully-qualifying it – I must have had a typo I didn’t catch because it didn’t work for me then. Thanks for the correction.

I’ve run across a few quirky things (quirky to me anyway) that have to be done differently between a worksheet module and a regular module. Do you know of any reference/list of such items? I tried to search for one but couldn’t find anything. It would be really handy to have something like that, imo.