VBA Code Debug Error

Hi, I have created a macro enabled excel spreadsheet using VBA code to link from one sheet to another with filtered values.

The problem is that when I use the sheet and click in the AH cell in the Opportunities tab I get an error - see Image1.

Image1.jpg

When I click on Debug, it takes me to the VBA - see Image2.

Image2.jpg

There are a couple of things puzzling me; 1 - When I click on the links in the AI cell in the Opportunities tab it works fine, and 2 - my colleague at work never sees the error I get. When he opens the file he is prompted to enable editing and then enable content in Excel (I am not prompted for this).

I have attached an example of the xlsm that I have created.

Any help would be greatly appreciated.

Many thanks,
Steve

Target is, by its nature, a Range - adding .Range when addressing it is confusing issues. So:

Please Login or Register  to view this content.

Hi, I am clicking AH6, AH7, AH8 and AH9 to get the error. Clicking cells AI6..AI9 work fine and take me to the Time worksheet filtered as it should be.

So, in column 34 (AH), you're trying to get a value 34 columns to the left of it - i.e. one column to the left of column A.

As that column doesn't exist the code is throwing an error.