Hello My friends,
I need simple macro which i will start from "Sheet1" via button, and it should define print area on "Sheet2". Start point of range is always A1, and end point taken from cell B1 (which will vary) on Sheet2"
Example file with manual solution is attached
Really appreciate for your help
Since you are using a Form Controls button, the macro should be copied to the standard code module1.
Right click your button to assign the macro.
Please Login or Register to view this content.
Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
Just when I think I am smart, I learn something new!
Thx for reply, but in the end I received an error Run time error 1004 - "Method Range of object _Global failed"
How I should modify code if target sheet name "Chart" and final point is cell "F69" on sheet "Chart"? This cell F69 contain only text "OS57", so full print area should be "A1:OS57"
Thanks in advance for helping me
I thought you said that cell B1 would contain the final cell reference.
As for the sheet name, just change "Sheet2" to "Chart". Where i used Range("B1"), substitute whichever cell you use to identify the last cell of the range to print.
This is a confusing statement. Are you saying that instead of B1 on sheet Chart that you are using cell F69 to define the last cell of the print range? If so, ThenThis cell F69 contain only text "OS57", so full print area should be "A1:OS57"
Please Login or Register to view this content.
Dear JlGWhiz,
It is not a confusion: cell F69 used in my real workbook and B1 only in example.
Sorry, but i received again error ("Compile error: Syntax error")
In my cell F69 calculated last column for the print area with formulas =CONCATENATE(F68,"57"), where F68 required last column of my chart and value 57 is last row and it always constant.
What can be an issue?
Thx in advance!
Ah, i found mistake
Anyway, thank you very much! Everything OK!
Try
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks