The *easiest and quickest* way to duplicate (copy) a sheet within the same
WB is:

Click on the sheet tab you wish to copy,
Hold down <Ctrl,
Then, drag the tab left (or right), just so the tiny sheet icon clears the
tab border,
Release the mouse,
Release <Ctrl.

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Michelle" wrote in message
...
My life saver!!!! Thank you 84 times over again! That did the trick and I
appreciate all of the responses. I've been playing with Excel for years
and
have just started to really dig into what this program can do. I took my
specialist certification from MS a few weeks ago and passed but I can tell
I
have a long way to go before I can be an expert.

Thanks again to all who replied!
Michelle

"Mike Middleton" wrote:

Michelle -

Perhaps I should have said I was trying to copy the same worksheet over
and over again but within the same workbook. Any suggestions? <

Edit | Move or Copy Sheet | Create a copy ...

Or, right-click the sheet tab, ...

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel


"Michelle" wrote in message
...
Please forgive my inexperience but I don't understand what you mean by
"myform". Perhaps I should have said I was trying to copy the same
worksheet
over and over again but within the same workbook. Any suggestions? I
tried
the select all, copy, paste special, all, but the page setup isn't
staying
with the copy. I have it set up for landscape, headers, footers etc
and
none
of that is like I set it up on the first page.

Thanks, Michelle

"JLGWhiz" wrote:

Forgot the quote marks for the name.

Worksheets("myForm").Copy After:=Worksheets("myForm")
ActiveSheet.Name = "myForm2"


"JLGWhiz" wrote:

The standard copy method for a worksheet should carry everything
over.
Sample code below.

Worksheets("myForm").Copy After:=Worksheets("myForm")
ActiveSheet.Name = myForm2

"Michelle" wrote:

I'm creating a form worksheet that will be repeated 84 times. Is
there a way
that I can copy this same form into each tab without having to do
a
page set
up for each worksheet? Each tab represents one filing cabinet
number
and the
form is for a Record Inventory. This form is just one page with
merged cells,
column headings etc.

Thanks!