Vaibhav Bhai, Sheet is working perfect. Great work!!
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poo
Great Cheers!!
On Thu, Mar 19, 2015, 7:34 PM Stephen E. Hale
wrote:
> Thank you so much Vabz, that is just what i was looking for. I really
> appreciate you help.
>
> On Thursday, March 19, 2015 at 1:30:02 AM UTC-7, Vabz wrote:
>
>> Try This:
>>
>> Sub CopyRename()
>> Dim sName As String
>>
Thank you so much Vabz, that is just what i was looking for. I really
appreciate you help.
On Thursday, March 19, 2015 at 1:30:02 AM UTC-7, Vabz wrote:
>
> Try This:
>
> Sub CopyRename()
> Dim sName As String
> Dim wks As Worksheet
> 'Worksheets("Master").Copy after:=Sheets(Worksheets
Try This:
Sub CopyRename()
Dim sName As String
Dim wks As Worksheet
'Worksheets("Master").Copy after:=Sheets(Worksheets.Count)
ActiveSheet.Copy after:=Sheets(Worksheets.Count)
Set wks = ActiveSheet
sName = Application.InputBox _
(Prompt:="Enter new worksheet name"
I have written a macro that copies from a master sheet and places the new
sheet after the last sheet. The macro is triggered by the "New Week >"
button on the master sheet. I want the macro to copy from the active sheet
instead of the master sheet. Any help is much appreciated. If anymore info
