Print Area Always Changes -
I use the code below to print a portion of a sheet. My problem is that the area always changes. The $A$476 should be the first cell in that column that contains "HEA" The "536" in $F$536 is the last row that contains data. There are conditional formats all the way down to row 1,000 but not data
Private Sub CommandButton1_Click()
Dim strCurrentPrinter As String, strNetworkPrinter As String
****strNetworkPrinter = GetFullNetworkPrinterName("Adobe PDF")
****If Len(strNetworkPrinter) > 0 Then ' found the network printer
********strCurrentPrinter = Application.ActivePrinter
********' change to the network printer
********Application.ActivePrinter = strNetworkPrinter
********ActiveSheet.PageSetup.PrintArea = "$A$476:$F$536"
********ActiveSheet.PrintOut** 'print something
********' change back to the previously active printer
********Application.ActivePrinter = strCurrentPrinter
********ActiveSheet.PageSetup.PrintArea = ""
****End If
End Sub
Obviously there is a function also that finds the full network printer name, I didn't think it was important, because my issue is the print area. Everything else works fine. If you need it let me know and I will post it.
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Print Previewed A Worksheet And Find A Tiny Image With A Small Portion Of The Print Area
I just converted from Excel 2003 to 2007 and print previewed a worksheet and find a tiny image with a small portion of the print area. When I look at the sheet in page break preview mode, I see the 8.5 x 11 sheet broken up into approx 77 smaller sheets. When I try to move the page breaks to include the whole sheet it states the change cannot be made as it will result in an image less than 10%. I have attached two images - the first shows the print preview I get, and the second show the multiple pages when I view in page break.
View Replies!
View Related
Vb Code To Set Print Area And Print Out
with creating vb code that will select certain rows in a spreadsheet, set the print area to those rows and print them out, and then reset the print area back to default. The data is all on one sheet, but is split into 5 different areas, each below the next, with the column headers at the top of each. e.g. header_____header_____header data_______data_______data data_______data_______data data_______data_______data header_____header_____header data_______data_______data data_______data_______data data_______data_______data and so on. At the press of a button it'll set the print area to the first section and print (the section includes the headers as well as the data). Then at the press of another button it'll set the print area to the next section. There could be any amount of rows of data in each section so it needs to cope with that.
View Replies!
View Related
Print Only Used Area
I have a sheet that will be about 5 pages long if printed. To minimize wasted ink and paper, using VB I would like to be able to have it only print the portion uses (data entered) along with a section at the top and bottom. The section at the top would print on the top of the first page and the section at the bottom would print on the last page. I know I could record a macro to select an area and print that but it would not do what I am trying to accomplish.
View Replies!
View Related
Variable Print Area
I'm using Excel 2003. I have a spreadsheet used for costing jobs giving a detailed breakdown of parts and time. Sometimes the customer requests a copy so I'm creating a macro for my boss that prints the spreadsheet, less the hidden columns that I don't want the customer to see. This I can manage. My question is this: Is there a way within the macro to set the print area to change to where the last cell is automatically? Each spreadsheet is a different length dependent upon the work required and setting a larger print area to compensate would use excess paper and ink.
View Replies!
View Related
Print Area Dimension
I used the macro recorder for this: ActiveSheet.PageSetup.PrintArea = "$A$1:$P$246" How would I change this to use variables? I need to set the print area to A( FR ) to P( LR ) Of course FR is first row, LR is last row
View Replies!
View Related
Auto Print Area
I have a hard time transitioning from other examples to my workbook. What I am after, is for the print area on 2 sheets to be set by the count of non-empty cells in column B on the first sheet. I have a maximum number of entries of 200 (rows) plus a header row. So, my entry #200 is in worksheet row 201 (cell B201) In cell B203 I use formula "COUNTA" to tell me how many cells are not empty. As an example, this number might be 36. The print area should be limited to worksheet row 37 (1 more than 36 due to the header row). My columns are always the same, A thru I. On a second worksheet, measurements are recorded, 10 per row. So, if I have 36 items to be measured, I use 4 rows (10 per row=3 full rows and 6/10 of the 4th row). I would like to have the print areas set automatically, based on this number in cell B203 (see above notes). On the 1st sheet (using example of 36 entries), my print area needs to be thru row 37, columns A thru I. On the 2nd sheet, my print area needs to increase 10 rows every time B203 increases by 10. (this 2nd sheet has other info on it, so when the print area increases, it needs to go in steps of 10 rows. as an example, if B203=8, then the print area on the 2nd sheet includes cell A1 thru cell K13, but if B203=12, then the print area would be cell A1 thru cell K23)
View Replies!
View Related
Print Area With A Macro
I am looking to set the print area with a macro, below is what I had hoped would work. It does not. I get unable to get Vlookup property of worksheetFunction class error. Sub Printzed() Start = Range("C6").Address Finish = Res = Application.WorksheetFunction.VLookup(I5, Range("prlu"), 2).Address myPrintArea = Start & ":" & Finish ActiveSheet.PageSetup.PrintArea = myPrintArea End Sub
View Replies!
View Related
Print Area VB Code
I wish the print area to be set based on the number entered into cell "D58". My code so far is: Sub Worksheet_SelectionChange(ByVal Target As Range) Dim NumPages As Range Set NumPages = Range("D48") Worksheets("Sheet6").PageSetup.PrintArea = Worksheets("Sheet6").Range(0, 0).Resize(NumPages * 21, 47) End Sub
View Replies!
View Related
Print Area Code
I have some code to select a print area depending on wether or not there is data in a cell. The code I have so far partially works but not quite like I need it to. Here's what I have, Sub selectprintarea() Select Case True Case Range("C5").Value > 0 Range("A1:M47").Select ActiveSheet.PageSetup.PrintArea = "$A$1:$M$47" Case Range("Q5").Value > 0 Range("A1:AA47").Select ActiveSheet.PageSetup.PrintArea = "$A$1:$AA$47" End Select End Sub It will select the print range if there is data in C5 but if there is data in C5 and Q5 it only selects the first print area. I know I need an "If - Else" or something of that nature but I cant figure that out. Also I need it to look at other worksheets not just the active one. I've tried a replacing the ActiveSheet with Worksheets (Sheet1). but that gives me an error.
View Replies!
View Related
Dynamic Print Area
I can define a name to calculate the desired Print Area for a page. For example, print_area_notes: =Notes!$A$1:INDEX(Notes!$A:$Z,final_Note,5). I can then use that name when defining the Print Area via Page Setup. The problem is it calculates the cell range immediately and substitutes that in the Print Area field. When print_area_notes changes the actual Print Area does not. Is there some formula I can enter in Print Area that will allow this value to be set dynamically? I have tried setting Print Area to =indirect("print_area_notes") but it doesn't like that. I could, but prefer not to, write a VBA function to set the Print Area but even then how do I set it to be called automatically? I'd prefer to be able to enter a formula and do it without VBA code because you then have the security issues every time the spreadsheet is opened.
View Replies!
View Related
Using Macro To Set Print Area
My macro selects cells containing data - then i want the macro to set the print area to those selected cells - works fine - but the selected cells won't be the same each time i run the macro. Here's how it looks now: Range("A1:M1").Select Range(Selection, Selection.End(xlDown)).Select Range(Selection, Selection.End(xlDown)).Select ActiveSheet.PageSetup.PrintArea = "$A$1:$M$76" The next time i run the macro the selected cells won't be A1:M76 - how do i have the macro set the print area to whatever is selected?
View Replies!
View Related
How To Auto Set Print Area
if there is a way with functions or code to automatically set the print area. I would like to have it set to start at A1 and print to column G & the first ROW with a zero value in column F. The ROW in which the first zero value appears will be the only variable. It will always be column G.
View Replies!
View Related
Non-contiguous Print Area Macro
I have a document which will require signatures after printed and want to keep the signature portion at the bottom of the page (currently rows 102-104). The problem is that the document will not need to be that long for every person and was wondering if it would be possible to have a macro that checks (C7:C:100), stops printing when it reaches the blank cells, and then prints those last 2 rows?
View Replies!
View Related
Print Area - Multiple Selections
Is there a way of selecting several print areas on several worksheets and printing it on ONE page? Selections will not be the same size. Also is there a way to lock your printareas? I would like to save the spreadsheet and open it up next month and the printareas are still there ready for me to print. It seems to reset after i have printed it
View Replies!
View Related
Adjust Print Area Macro
The macro below works perfectly except for one problem. I only want it to set the print area from Column A - Column M . It currently selects data i have in Columns N and beyond and i do not need that to print. From A - M is 13 columns.
View Replies!
View Related
Print The Area With Dynamic Setup?
My worksheet (excel 2003) contains lots of details and requires different page setup for printing e.g. (a) Cells B3 to R3 downwards: Data details, which user may add more rows of records (b) Cell S1-Z20: Data summary (formula) linked with (a) (c) Cell AA1-AK15: Pivot Table linked with (b) Therefore, I set buttons, linked with 3 macros to do page setup for the different ranges. However, I had some problems i.e. 1. For print area (a), how to define print area parameter in a macro to check the last row of data. i.e. check for last "blank cell" of column "C-E" (others columns contain formula before input the data) 2. In the future, if I or user insert new columns in area (a), is it possible to setup macro that have print area for (a) - (c) shifted without changing the parameter in the macro?
View Replies!
View Related
Set Print Area Through Code
I am having trouble setting print area on rows that can vary from 100 to 6000 rows. This code works good except that the print area cuts off the last row of data every time. "AreaBegin"=row 6 and "AreaEnd" = to last row after a set number of rows have been inserted based on a counter. Basically how do I get this code to capture the last row for print area? Sub SetArea() ActiveSheet.PageSetup.PrintArea = Range("AreaBegin", Range("AreaEnd").End(xlUp)).Address
View Replies!
View Related
Find Last Column In Print Area
I need to use macro to find the last column index number within the print area. My cell sizes change depending on the data entered so the last column in the print area changes. The code I want to implement involves putting a title at the top of the page and creating a border that spans the width of the page. This is what I have so far: LastColumn = Cells.SpecialCells(xlLastCell).Column ' replace this with last column in print area Rows("2:2").Select Selection.Insert Shift:=xlDown Range(Cells(1, 1), Cells(2, LastColumn)).Select With Selection .MergeCells = True .HorizontalAlignment = xlCenter .VerticalAlignment = xlCenter End With With Selection.Borders(xlEdgeLeft) .LineStyle = xlContinuous .Weight = xlMedium .ColorIndex = xlAutomatic End With
View Replies!
View Related
Set Print Area By Month
I'm trying to set-up the print area for my actual & Forecast. I have two years of data from A1 to U735, dates are in column B. Is it possible with a macro to set up the print area for each Month?
View Replies!
View Related
Set Print Area To Used Cells
I am trying to write a macro that will allow the user to print out the sheet from the beginning to the last used row. The catch is that I have formats and formulas all the way to the end (A1:O319). My basic format is a frozen Pane (for a header and summary) from A1:O18, then the user inputs their data starting on B19. The columns never change, and the rows will be variable. I tried a dynamic range to no avail, and have most recently tried this Sub printter() Dim myrange Dim Rng, cell As Range Set myrange = Range("A320").End(xlUp) Set Rng = Range("A1:" & myrange.Address) For Each cell In Rng If cell = "" Then myrange = cell.Address MsgBox cell.Address ActiveSheet.PageSetup.PrintArea = "$A$1:O" & cell.Row ActiveSheet.PrintOut Exit Sub End If Next End Sub My next plan would be to write to check to see the last used cell in column B, since that cell has only formating, no formula, and is a required entry cell
View Replies!
View Related
Vba To Set Print Area
Looking for a macro that will set the print area on an accounts spreadsheet to the last non blank row, bearing in mind that all the rows contain formulas, have tried some macros but they assume the cells with formulas in them are non blank
View Replies!
View Related
Macro To Select An Area, And Print Selection
I need a macro to select the area within the blue invoice sheet box, so everything within the blue invoice sheet box is selected , and then the selection should be printed. I will have hundreds of these invoice slips made, right below each other, i was wondering once this is done, is there an easier way to to have each invoice selected, instead of making a custom button for each sheet ( which selects just that invoice , and prints that selection ). ( Column m through v, starting at row 2 stoping at row 68, is the selection required in this example, everythign within the blue box. ).
View Replies!
View Related
Set Print Area Of Dynamic Range
I have a sheet with a top portion like a fax cover letter. Starting at row 17 I merged from B thru L. This is where the user will type in a message. The message can extend several pages long, so I merged about 100 rows same as 17. My sheet only will extend to column N. There may be instances where the user may leave several rows blank in between what they type. I am looking for a way to set the print area from A1 to the last row of data and not the last row with formatting. I have a command button the user is supposed to click when they want to print the sheet. This is acceptable, but if there was a way around that it would be better. Note: I do have code in the sheet that will automatically adjust the row height in the merged cells if the data gets too wide. I do not want to upset that. I have just recently started to learn VBA, so my knowledge of the various commands and syntax is limited. This is what I have right now that doesn't work. Private Sub CommandButton2_Click() Dim LastCell, DataCells As Range Dim LastDataRow As Integer Set LastCell = ActiveSheet.Cells.SpecialCells(xlLastCell) Set DataCells = ActiveSheet.Cells.SpecialCells(xlconstants) LastDataRow = DataCells.Cells(DataCells.Cells.Count).Row ActiveSheet.PageSetup.PrintArea = Range(ActiveSheet.Cells(1, 1), ActiveSheet.Cells(LastDataRow, LastCell.Column)).Address ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True End Sub
View Replies!
View Related
Set Print Area From Selected Range
I have some code which selected a certain amount of columns depending on whether they contain values or not. Once I have this range set and I select it I want to set this as the print area. I am not quite sure how to do this. for example I tried: rngUnion.Select ActiveSheet.PageSetup.PrintArea = ActiveCell. CurrentRegion.Address
View Replies!
View Related
Select The Print Area For Several Pages In A Workbook
I've set up a short bit of code to select the print area for several pages in a workbook, but have no idea how to get the code to "activate". I tried placing a command button on a page to activate the code, but for some reason it won't see or act upon any sheets outside the sheet the command button is on. Same goes for the "event" proceudres on pages (activate, change.selection, etc).
View Replies!
View Related
User Defined Print Area Macro
I am looking to create a macro that will ask the user to define the row number of the beginning and ending locations that they would like to print. The columns are fixed in that the first starting row will be from column A and the ending row will be column M. I have built a pipe tally used in the oilfield that keeps track of large amounts of pipe figures but very often is the case that there is the need to print a section of the tally data in reference to a certain depth. With the vast knowledge base located here I was able to build the first macro that prints the whole active tally but now I need something more refined. Below is one of the copies of the macro that I was trying to get to work and it is missing a couple of things but the most important part shows up and that is how to get the inputbox variables into the defined print area. Sub TallyVariable() Dim StartRow As String Dim EndRow As String StartRow = InputBox("Please Enter Starting Row you would like to print") EndRow = InputBox("Please Enter Last Row you would like to print") ActiveSheet.PageSetup.PrintArea = "A" & StartRow.Address:"M" & EndRow.Address End Sub
View Replies!
View Related
Set Print Area Based On Sort
I have a worksheet which contains data for 6 different groups. I have a sort macro already that sorts them into groups (group 1, group 2, etc.) What I want to do know is set the Print Area so I can just print each group individually with a button("print group 1", etc.) The worksheet is set up as follows: Columns B-H are the data I want to have printed. The number of rows is different for each group. I want to set the Print Area based on Column H. So, if H=1, set the Print Area for Columns B-H and all rows that have H=1. This seems like it should be simple enough, but I haven't quite been able to put the pieces together yet.
View Replies!
View Related
Automatically Define Print Area Before Printing
I've seen code to set the print area for a dynamic range. However, how can the print area be defined by these parameters: A1 to one extra blank row below the last cell of data in column A (height), and last column with data in row 12 (width). Here is what I'm starting with... Private Sub Workbook_BeforePrint(Cancel As Boolean) ActiveSheet. Names.Add Name:="Print_Area", _ RefersTo:=Range(Range("A1"), _ Range("A1:IV65536"). Find(what:="*", searchorder:=xlByRows, searchdirection:=xlPrevious, after:=Range("A1"))) End Sub I have copied formulas in other columns down beyond what the last row of col. A will be. Also, this will need to be applied to about 7 sheets in one book.
View Replies!
View Related
Set Print Area Based On A Condition
I have a worksheet named "TQUOTE" with the print area defined as A1:E:286 resulting in 5 pages printing ,however if there are only 3 pages of data I will be left with 2 blank pages being printed. (along with the header rows which are set to repeat for each page ). I should mention this worksheet is included in a list of sheets to print based on the response to a user form. Would it be possible to have the print area change based on the an empty cell that related to the next page break? eg. If the page break for page 1 ends at row 55, if a cell in row 56 were empty then set the print area to be A1:E55 If the page break for page 2 ends at row 85, if a cell in row 86 were empty then set the print area to be A1:E85 and so on ?? I do not have the skills yet to write this macro , and i bow to thiose
View Replies!
View Related
Limit Print Area To Cells With Values
In the range A1:H89 I have expanding and retracting values - all of which is determined by the numbers in column A. Column A is simply A1+1 copied down. The value of A1 is determined by the value of another cell, based on age. If the value in column A exceeds a specific figure (let's say 50), formulas in columns B - H result in answers of "" (this is "nothing"?). Assume that the value of 50 is reached in A20. All cells from A21 (inclusive) down, including B21 - H21, will have the values "" in them and show up as nothing on my screen. When I print, I'd like to only print those cells where data is, i.e. cells A1:H20. Sub Drukwerk() With ActiveSheet.PageSetup .PrintTitleRows = "$7:$9" .PrintTitleColumns = "" End With LastRow = Range("A" & Rows.Count).End(xlUp).Row ActiveSheet.PageSetup.PrintArea = "A1:H" & LastRow ' ActiveSheet.PageSetup.PrintArea = "$A$1:$H$89" With ActiveSheet.PageSetup .LeftHeader = "" .CenterHeader = "" .RightHeader = "" .LeftFooter = "" .CenterFooter = "".......................
View Replies!
View Related
Set Print Area From Dropdown List
Is it possible to set a print area and then actually print it according to what is chosen from a dropdown list ? Ie If 'Print area 1' is chosen, it selects A5:D50 & A5:L50 and then prints If 'Print area 2' is chosen, it selects A5:D50 & M5:S50 and then prints
View Replies!
View Related
Macro To Set Print Area W/o Hidden Rows
We run a small gardening shop and use a simple spreadsheet to track of various things. Row A contains headers, with the data following in the rows underneath. This table is now quite large, and we therefore hide 600 or so rows so that only rows with data from the last week is shown. We often need to print this for easy reference. I currently do this by highlighting the area I want and setting it as print area. The print therefore doesn't include hidden cells, which is what I need. The problem we have, therefore, is that we have to manually select this print area each time. My experience with macros is VERY limited, to the point where I can record one which will select the print area and print. However, as the list gets longer and more rows are hidden the range obviously needs to change, and my simple macro will not keep up. So my question is as follows. Is there a simple macro I could write to assign to a button that could "keep up" with the moving range? So either it always prints the header row and the, for example, 50 rows beneath (exlcuding the hidden ones), or, even better, it prints the header row and all rows with data in them that are relevant to the last week. Each row has a cell for the date it concerns so assume this may be possible?
View Replies!
View Related
Setting Variable, Discontinuous Print Area In A Macro
I need to write a macro to set the print area to the first two columns (A & B), and the last 12 columns (the last column may change). In both cases I need to print all rows (start is row 1, last row is variable). I am trying to achieve something like the "Freeze Pane" effect with the printer. The first two rows contain column headers (dates). The first two columns contain information that needs to be included on the printout, whilst the last 12 columns contain the most recent data. Various cells withing the selected ranges may be blank, but no row or column will be entirely blank.
View Replies!
View Related
Create User Settable Print Area With Dynamic Ranges
Once a user of my workbook has input various price levels on the Input Page, the data is sorted on the output page. As the data on the Output Page is quite vast and not all of it is relevant on a particular day, the user is interested in just printing a certain range of data that are in 5 columns. I am trying to figure out how to set up a macro that will allow the user to enter into an Input Box the range to print (ie. Cells C25:G60). I found one example on this site listed below that allows one to do that but I would like to make it more user friendly. I do not want to make the user have to write out Excel cooridinates. Specifically by allowing the user to input in the Input Box a High price level in Column C and a Low Price level in Column C ; The macro will look in Column C for the highest instance of this High Price and begin the range down to the last instance of the Low Price (there can be several instances of the exact price level.) The macro would then create the print preview of the cells Cxx:Gyy. Sub SelectPrintArea() Dim PrintThis As Range ActiveSheet.PageSetup.PrintArea = "" Set PrintThis = Application.InputBox _ (Prompt:="Select the Print Range", Title:="Select", Type:=8) PrintThis.Select Selection.Name = "NewPrint" ActiveSheet.PageSetup.PrintArea = "NewPrint" ActiveSheet.PrintPreview End Sub
View Replies!
View Related
VBA - Adding Border Line To Bottom Row Of Set Print Area
I am using the following macro to set print area which I found on the net. I am trying to modify it as I would also like to place a border line on the bottom row but cant find anything to assist me despite searching through several threads. Dim myrange As String With ActiveSheet.Range("A:A") myrange = .Find(What:="*", After:=.Range("A1"), LookIn:=xlValues, LookAt:=xlPart, _ SearchOrder:=xlByRows, SearchDirection:=xlPrevious, MatchCase:=False).Address End With ActiveSheet.PageSetup.PrintArea = "$K$1:" & myrange End Sub
View Replies!
View Related
Set Print Area For Range Bounded By Row & Column Header
I want to select a range in a spreadsheet and then set it as the print area. the last column I want to be selected is contains the text data "ABC" in row 1 and is the only column with data "ABC" in row 1. The last row I want to select contains the text data "DEF" in column 1 and is the only row in column 1 containing the data "DEF". Basically I want to select the range [A1:column("ABC")row("DEF")] and then set it as the print area.
View Replies!
View Related
Macro To Print Active Area Excluding Cells With Forumula That Doesn't Return Value
Trying to put together a macro that looks down active sheet for all cells that contain a value, sets a print area and then prints ! Is this possible? FYG, I have a column that run from 3 - 2000, which contains a formula, which may produce a value depending on corresponding cells. I used this code from a post on a similar topic, but excel is complaining code in bold Private Sub Print_Area_Click() Dim lastCell As Range Set lastCell = Cells.SpecialCells(xlCellTypeLastCell).Offset(1, 0) Do Until Application.Count(lastCell.EntireRow) 0 Set lastCell = lastCell.Offset(-1, 0) Loop ActiveSheet.PageSetup.PrintArea = Range(Cells(1, 1), lastCell).Address End Sub
View Replies!
View Related
Graph The Following Data In An Area Chart With Line Charts Superimposed On The Area Chart
I am trying to graph the following data in an area chart with line charts superimposed on the area chart. I have a lot of data (and a lot going on) so I'm trying to figure out the best way to show this in excel from a functional standpoing (i can't get this to work in excel!!) to also an asthetic standpoint (dont want it to look terrible or illegible). This is what I'm trying to chart: 1) Weather data (temperature) by region: So one region, would be: Northwest I would like the "area" (so a shaded region) to be the min/max of the temperature data for each month. 2) I would like to show the temperature for each year as a line graph on the chart - so you can see if a year falls in or out of the shaded region. 3) I would like to show a company's sales increases across the same months per year as separate line charts. I may choose to just show the biggest outlier year in the end... or to show 2006 (the latest data). What I am trying to convery with the chart is that the company's sales is or is not tied to weather deviations. I have attached an excel file with the data. I haven't been able to use the area chart or get a two axis chart to work or get it to look even remotely professional.
View Replies!
View Related
Allow Users To Print Hidden Sheet But Not Change Print Settings
I am having trouble disabling the "Preview" button when calling Application.Dialogs(xldialogprint) in XL2003. I have an xlSheetVeryHidden worksheet containing a form which is made visible programatically when the user wishes to print a copy (code below). I want the user to be able to have access to the functionality of the xlDialogPrint dialog (i.e. select desired print destination, number of copies, pages per sheet etc.) but I also want to prevent them modifying the page setup of the protected worksheet by initiating a preview from the print dialog. Private Sub btnPrintReturnForm_Click() wbkRUSC.Unprotect sysPass 'unprotect workbook to enable changes to sheet visibility ' (sysPass is project constant string containing password) shtStaffForm.Visible = xlSheetVisible 'make staff form visible shtCalc.Visible = xlSheetVeryHidden 'hide main calculator in case user gets smart and hits..............................
View Replies!
View Related
Stop Print Macro Firing Before Print Event
I have a "submit" button macro which user would click after he has finished his input. This macro would update a reference number on the worksheet named "orange" and then print out this worksheet. My purpose is "orange" is printed out with a reference number. Below is the 1st code.....
View Replies!
View Related
|
TRACKER
