LinkBack URL
About LinkBacks
Hi
I need a macro that will set a variable print area based on whether there is a value in Column A. The whole range to select to print would be columns A to N. I have tried adapting code from this forum but to no avail.
Can anyone help?
Thanks
Mark
Hi
I need a macro that will set a variable print area based on whether there is a value in Column A. The whole range to select to print would be columns A to N. I have tried adapting code from this forum but to no avail.
Can anyone help?
Thanks
Mark
Last edited by markrennolds; 05-04-2010 at 01:55 PM.
So if there is a value in A10 you want the print area to be set as A1:N10 no matter what other rows are populated in the other columns?
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Something like this:
Option Explicit Sub SetPrintArea() Dim LR As Long LR = Range("A" & Rows.Count).End(xlUp).Row ActiveSheet.PageSetup.PrintArea = "$A$1:$N$" & LR End Sub
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks