'Function(a1) how to get a1 inside my function (Excel VBA)

I need to create a function that outputs a result based on whether a cell is merged or not.

To do that I need to check if each cell from a1...aN is merged or not. But I haven't found a way to get the cell "a1" when I call function(a1). All I can get is the value of the cell and not the cell itself.

Is there a way to solve this? Thanks in advance



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source