i have several worksheets (ie a,b,c,etc) that have variations of the same
information on them. I would like to be able to manually select a cell on
worksheet "a" and then by activating a macro ....delete the row that it is in
across all of the worksheets.
--
dr chuck

It's pretty easy to do it manually. Select the sheets you want this to
happen to (Ctrl-click or Shift-click on their tabs, or right click a
worksheet tab and pick Select All Sheets).

This puts you in 'Group mode'. What you do to one sheets affects all
selected sheets at that point.

--
Jim
"dr chuck" <(E-Mail Removed)> wrote in message
news:01A2026D-67C5-47F8-9F1F-(E-Mail Removed)...
|i have several worksheets (ie a,b,c,etc) that have variations of the same
| information on them. I would like to be able to manually select a cell on
| worksheet "a" and then by activating a macro ....delete the row that it is
in
| across all of the worksheets.
| --
| dr chuck

Thanks Jim,

For a person who is learning how to use excel and VBA by trial and error and
necessity... sometimes the obvious and easy solutions are quite elusive.
--
dr chuck


"Jim Rech" wrote:

> It's pretty easy to do it manually. Select the sheets you want this to
> happen to (Ctrl-click or Shift-click on their tabs, or right click a
> worksheet tab and pick Select All Sheets).
>
> This puts you in 'Group mode'. What you do to one sheets affects all
> selected sheets at that point.
>
> --
> Jim
> "dr chuck" <(E-Mail Removed)> wrote in message
> news:01A2026D-67C5-47F8-9F1F-(E-Mail Removed)...
> |i have several worksheets (ie a,b,c,etc) that have variations of the same
> | information on them. I would like to be able to manually select a cell on
> | worksheet "a" and then by activating a macro ....delete the row that it is
> in
> | across all of the worksheets.
> | --
> | dr chuck
>
>
>