Right click on the sheet tab and select view code and put in code like this

Private Sub Worksheet_Change(ByVal Target As Range)
Set rng = Target.MergeArea
Select Case rng.Address(0, 0)
Case "A10"

Case "B2:D3"

End Select
End Sub

then call the procedures within the case statements or put your code there.

--
Regards,
Tom Ogilvy


"Moises" wrote:

I have both cases, one with a single cell like A10, and the second case a
range of cells with a merge format so they are displayed as a big cell (for
example range b2..d3, with a merge format).
Thanks
--
Moises


"Tom Ogilvy" wrote:

Which is it: A10 or a range of cells that have a format of merge so they
look like a big cell?

--
Regards,
Tom Ogilvy


"Moises" wrote:

What do I have to code in order to call a macro after a select, or clikc on a
paricular cell?, for example, I would like to run the macro after a select
the cell A10 or a range of cells that have a format of merge so they look
like a big cell ?
Thanks
--
Moises