VBA Code:
ActiveSheet.PageSetup.PrintArea = "$B$13:$V$56,$B$59" & Cells(98, Cells(100, 1).Value)
I have the above code that needs to be modified. The second page column value will change from time to time. So i have the Value in "A100" to give me the column number in this case its "BE" so value "A100=57
the row will always be 98. so I need the above code to read:
VBA Code:
"$B$13:$V$56,$B$59:BE57"
any help is greatly appreciated.