Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copying sheet with macro
On my worksheet (totals hours worked each day for all employes) I have
macro assigned to a button (update) on the worksheet which copies th sheet, deletes all data and then updates the dates to the next week The problem is, when I click the button and it copies the worksheet i always uses the original sheet (sheet1) instead of using the ne updated sheet (sheet2,3,ect.) when I run the macro each additiona time. I understand that the macro is referencing sheet1, but I don' know how to make it reference the active sheet. Help would be greatl appreciated. Thanks -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
copying sheet with macro
mcrmike < wrote:
On my worksheet (totals hours worked each day for all employes) I have a macro assigned to a button (update) on the worksheet which copies the sheet, deletes all data and then updates the dates to the next week. The problem is, when I click the button and it copies the worksheet it always uses the original sheet (sheet1) instead of using the new updated sheet (sheet2,3,ect.) when I run the macro each additional time. I understand that the macro is referencing sheet1, but I don't know how to make it reference the active sheet. Help would be greatly appreciated. Thanks. Search in your code the references to sheet1 and change it for ActiveSheet. Regards, -- Beto Reply: Erase between the dot (inclusive) and the @. Responder: Borra la frase obvia y el punto previo. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
copying sheet with macro
Thanks, Beto it worked fine, things are good with the world again.
--- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help Taking alot data from one sheet (if not blank) and copying toa list on another sheet. | Excel Worksheet Functions | |||
Dynamic column chart - copying from Sheet to Sheet. | Excel Discussion (Misc queries) | |||
Dynamic column chart - copying from Sheet to Sheet. | Charts and Charting in Excel | |||
2 questions, copying data from sheet to sheet and assigning macro | Excel Worksheet Functions | |||
macro stops copying sheets into a book after the 11th sheet | Excel Programming |