LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Macro to print multiple purchase orders

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Purchase Orders americasmattress8888 Excel Discussion (Misc queries) 1 March 2nd 07 04:33 PM
require macro or code for purchase order to do the following: jatman Excel Worksheet Functions 0 August 11th 06 06:02 AM
Error using a macro to print multiple pages. [email protected] Excel Discussion (Misc queries) 2 June 21st 06 06:47 AM
Consecutively Number Purchase Orders debcps Excel Worksheet Functions 1 May 18th 05 03:51 PM
im looking for an excel template to track purchase orders against Jon Excel Discussion (Misc queries) 1 April 5th 05 01:58 PM


All times are GMT +1. The time now is 06:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"