Dear Experts
How to assign Print range
from range("c3") to range("P" & .Rows.Count).End(xlUp).Row
I want to print from c3 to last used row of Column P
Please help
Dear Experts
How to assign Print range
from range("c3") to range("P" & .Rows.Count).End(xlUp).Row
I want to print from c3 to last used row of Column P
Please help
Hi,
[vba] With ActiveSheet 'or whatever sheet reference you want
.PageSetup.PrintArea = .Range("c3", .Cells(.Rows.Count, "P").End(xlUp)).Address
End With[/vba]
Matt
You could also to this site and review their method.
http://www.dailydoseofexcel.com/arch...area-with-vba/
(Sorry Matt, didn't mean to steal your thunder on this one)
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
Never a problem, I'm not territorial (or have much thunder to steal anyways )
Matt