Solved: Setting the print area for used rows and columns

[enfantter]

Hey once again all,

Just encountered yet another problem.
Im runing a macro where i want to set the printing area as all the used columns "A:L" and the rows "9:[lastrow]".

My code is like this:
Dim y As Long, lastCell2 As range
y = ActiveSheet.UsedRange.Rows.Count
Set lastCell2 = Cells.SpecialCells(xlCellTypeLastCell)
ActiveSheet.PageSetup.PrintArea = range(Cells(9, 1), lastCell2).Address


but Im guessing that im missing the point here ...
Anyone can help?!

[Bob Phillips]

Works fine for me. What is happening?

[enfantter]

sorry
for me its marking all rows instead of stopping at the last one ...
maybe its my sheet...

[Bob Phillips]

Yeah, try this out

http://www.contextures.com/xlfaqApp.html#Unused

[enfantter]

exactly - thnx!!