Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Apply Macro on Multiple Worksheets in a Workbook
Hi Norman, Thanks for helping! It's a great start, but unfortunately the cod runs in a loop in the selected worksheet and won't apply the formattin code to the next worksheet. Any other ideas? Thanks a million -- Agne ----------------------------------------------------------------------- Agnes's Profile: http://www.excelforum.com/member.php...fo&userid=1463 View this thread: http://www.excelforum.com/showthread.php?threadid=26261 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Apply Macro on Multiple Worksheets in a Workbook
Hi Agnes,
To demonstrate that my code operates sequentially on each worksheet, run this minor adaptation: Sub Tester() Dim sh As Worksheet For Each sh In ActiveWorkbook.Worksheets MsgBox sh.name Next sh End Sub You may need to adapt your format code to replace activesheet or sheet names with the variable sh. If this is a problem, post your code and I will adjust it in this respect. --- Regards, Norman "Agnes" wrote in message ... Hi Norman, Thanks for helping! It's a great start, but unfortunately the code runs in a loop in the selected worksheet and won't apply the formatting code to the next worksheet. Any other ideas? Thanks a million! -- Agnes ------------------------------------------------------------------------ Agnes's Profile: http://www.excelforum.com/member.php...o&userid=14630 View this thread: http://www.excelforum.com/showthread...hreadid=262619 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to apply macro across multiple worksheets within a workbook | Excel Discussion (Misc queries) | |||
Combine worksheets in multiple workbook in one workbook with a macro | Excel Discussion (Misc queries) | |||
Apply Macro to all worksheets in a workbook except one | Excel Discussion (Misc queries) | |||
Excel should apply names in all worksheets of a workbook | Excel Discussion (Misc queries) | |||
Apply Macro on Multiple Worksheets in a Workbook | Excel Programming |