Activesheet.pagesetup.printarea in vba

Lance Roberts Vin Vin 2 2 gold badges 5 5 silver badges 6 6 bronze badges. Add a comment. Active Oldest Votes. I would combine a dynamically resizing named range with a VBA method.

Improve this answer. Stephen Collins Stephen Collins 3, 8 8 gold badges 36 36 silver badges 57 57 bronze badges. Select With ActiveSheet. FullName 'to show address. Chris Rae Chris Rae 5, 2 2 gold badges 33 33 silver badges 49 49 bronze badges. I have tried this and it Worked for me. Bhanu Pratap Bhanu Pratap 1, 13 13 silver badges 15 15 bronze badges. I had Application. Then ActiveSheet.

Address ' which does the job for me. 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: Function HLink rng As Range As String 'extract URL from hyperlink If rng 1.

Address End Function The other sub being activated did not make more apparent sense. Sep 19, ClaireS. Replies 1 Views Nov 15, GWteB. Question Macro to automatically print. Nov 1, pure vito. Replies 3 Views Oct 25, bobkap. Jmorrison67 Oct 5, Excel Questions 2. Replies 10 Views Oct 20, DanteAmor. Understanding data is crucial, and the easiest place to start is with Microsoft Excel.

Forum statistics Threads 1,, Messages 5,, Members , Latest member jamesw Sub SetArea ActiveSheet. End xlUp. You can use this macro to set the print area to the used range of the activesheet. Address End Sub Hope this helps.

Posted by Ghentry on January 14, AM. Change the name of the active worksheet. Adds two hyperlinks to active sheet. Inserts the sheet names into the SheetNames array. Macro for changing page setup to landscape orientation. Use For loop to fill a range.