Returned values are different when macro is ran from a button versus when ran from Developer ribbon

[anglais428]

Strange one...

I have a macro that returns data values in a matrix table format.
When I run the macro from the Developer ribbon (Developer - Macros - macro_name - Run) it returns the values I need.
When I run the macro from a button it returns lower values.

The macro looks at two columns and it seems like when I do the former it catches both; however when I do the latter it only catches the first column.

How can this be if they are both running the same macro?

 

[steve the fish]

First thought would be you dont explicitly declare your sheets when working with Ranges. The button would always be in the same sheet. You could be in any sheet when running from the developer tab. But unless we see the macro it would be hard to guess.

 

[anglais428]

Brilliant first guess! That was it exactly! Many thanks