A pointer going nuts but with some insistence, a repeated folly which supposes some logic behind. Here is the function most often triggered in another module in another workbook while not being programmatically activated at all, I repeat : it does not make logical sense to me but so it is:. Hyperlinks 1. Address End Function. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow.
Learn more. Asked 10 years, 10 months ago. Active 2 years, 11 months ago. Viewed 42k times. I have a table with a fixed number of columns, but the number of rows vary week on week. Is there a macro I can create to set the print area automatically of this table? Improve this question. Lance Roberts Vin Vin 2 2 gold badges 5 5 silver badges 6 6 bronze badges. Add a comment. I am trying to find a macro that will set the print area.
The first column is A, the last column will always be M. The first row to print will always be 1, the variable will be the last row with data. Any help would be appreciated. Address End Sub. Click here to reveal answer. Use a custom number format of , 0,K. Each comma after the final 0 will divide the displayed number by another thousand. Try Code:. Thanks MARK That's perfect. Best Regards Kenn. Resolute New Member.
You must log in or register to reply here. Similar threads. Replies 3 Views Oct 25, bobkap. It's easy to join and it's free. Register now while it's still free! Already a member? Close this window and log in. Join Us Close. Join Tek-Tips Forums! Join Us! By joining you are opting in to receive e-mail.
Promoting, selling, recruiting, coursework and thesis posting is forbidden. Students Click Here. PrintArea" returned empty string "" only. This just means you have no defined print area setup. To add to dgillz's response. If the print area is not set then excel prints the used range.
Worksheets "Sheet1". UsedRange Gavin.
0コメント