Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have one file with 2 worksheets, One called PurchaseOrder (PO), the other
called PurchaseOrderData (POD). On the PO sheet I have the following: Current Market Order 9 First Market Order to Print: 3(cell is named StartRow) Last Market Order to Print: 6(cell is named EndRow) I am having problems creating a macro that will print just the specified purchase orders. Below is a macro that I copied from another help question. Sub PrintPurchaseOrders() ' ' PrintPurchaseOrders Macro ' Prints selected range of Purchase Orders Dim StartRow As Integer Dim EndRow As Integer Dim Msg As String If StartRow EndRow Then Msg = "ERROR" & vbCrLf & "The starting row must be less than the ending row!" MsgBox Msg, vbCritical, APPNAME End If End Sub I'm still having problems getting it to print. Nothing at all happens when I click the button I have assigned the macro to. Help please. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Purchase Orders | Excel Discussion (Misc queries) | |||
require macro or code for purchase order to do the following: | Excel Worksheet Functions | |||
Error using a macro to print multiple pages. | Excel Discussion (Misc queries) | |||
Consecutively Number Purchase Orders | Excel Worksheet Functions | |||
im looking for an excel template to track purchase orders against | Excel Discussion (Misc queries) |