"Myrna Larson" wrote in message
...
I haven't seen the beginning of this thread, but if you are trying to
create a macro that does
nothing but what you show below, you don't need a macro and button for
that. Excel has a
shortcut key. From Help:

CTRL+SHIFT+* (asterisk): Select the current region around the active cell
(the data area
enclosed by blank rows and blank columns). In a PivotTable report, select
the entire PivotTable
report.

What version of Excel are you using? Have you set the TakeFocusOnClick
property of your button
to False? If you haven't, that may be the problem. There's no ActiveCell
once you click the
button (it's a bug, fixed in later versions).

That did it! And I never would have thought to look there. Thank you!

Excel 97

-gk-