Help - I'm sure it must be simple
Thanks.
How do you 'say' - select the active sheet?
"Bob Phillips" wrote:
ActiveSheet.Copy after:=Worksheets(Worksheets.Count)
ActiveSheet.Name = "May"
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Anita" wrote in message
...
Hi
I don't know a lot about vba except what I see in macros.
What I want to do is the following...
I have an accounts spreadsheet.
In column d in Januarys sheet I have totals (which are formulas)
I need to copy the entire sheet and paste the values from column d in
January into column b for next month as brought forward values fo and so
on.
I can do the copy paste values bit using a macro.
What I want to do that I can't do with a macro is be able to say 'copy the
active sheet and move to end', so that if I am on Aprils sheet I click a
button and it creates a new sheet that I can then manually rename as May.
It
contains the brought forward figures from the previous month.
I only need the code for the copy active sheet and move to end bit - can
anyone help?
Thanks
Anita
|