View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default deleting rows across worksheets?

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" wrote in message
...
|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