Here it is:

Private Sub App_SheetSelectionChange(ByVal Sh As Object, _
ByVal Target As Excel.Range)
If Sh.AutoFilterMode Then MacroA

Thanks!


"Barb Reinhardt" wrote in message
...
You may want to post your selectionchange code.
--
HTH,

Barb Reinhardt



"pwz" wrote:

I have added an Selection Change Event in my workbook. However, problem
is
found when I perform copy and paste. The data is "lost" (the "Paste" is
in
light grey) after I has right clicked another cell. Any solution for
this?
Thanks in advance for any help!

Pat


.