Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
The following macro creates a routing slip for two specific individuals. How
can I change this to create a routing slip based on the names entered in specific spreadsheet cells? Sub Macro5() ' ' Macro5 Macro ' Macro recorded 8/8/2005 by Xavier Cougart ' Sheets("PAF Form").Copy ActiveWorkbook.HasRoutingSlip = True With ActiveWorkbook.RoutingSlip . Recipients = Array("Roger Clemens", "Joe Torry") . Subject = "Routing: Book1" . Message = "" . Delivery = x1OneAfterAnother . ReturnWhenDone = True . TrackStatus = True End With ActiveWorkbook.Route |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Create a report with selected rows based on the content in a cell | New Users to Excel | |||
Create Total based on lookup value | Excel Worksheet Functions | |||
how to create and use a new spreadsheet based on a template | Excel Discussion (Misc queries) | |||
How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) | |||
Create a total based on multiple conditions is not giving correct. | Excel Worksheet Functions |