Macro to change print settings based on condition.

[boweryreserve]

Hello. I am pretty new to Visual Basic. I am trying to write a macro that will automatically adjust the print settings in a document based on the value in column 20 (column T) being = "Show". I am building a template where users will enter information. There will an adjacent worksheet that will summarize that information. Rather than having a user adjust the print settings manually, I want the macro to automatically adjust to include all rows where the cell = "Show". Below is a mini example of what the worksheet will look like. Thanks very much for your help.[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][TABLE="width: 1387"]
<tbody>[TR]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]6[/TD]
[TD]7[/TD]
[TD]8[/TD]
[TD]9[/TD]
[TD]10[/TD]
[TD]11[/TD]
[TD]12[/TD]
[TD]13[/TD]
[TD]14[/TD]
[TD]15[/TD]
[TD]16[/TD]
[TD]17[/TD]
[TD]18[/TD]
[TD]19[/TD]
[TD]20[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Project Name/Description[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Show[/TD]
[/TR]
[TR]
[TD]Project 1[/TD]
[TD] 0.12 [/TD]
[TD] 0.13 [/TD]
[TD] 0.99 [/TD]
[TD] 0.29 [/TD]
[TD] 0.10 [/TD]
[TD][/TD]
[TD] 0.28 [/TD]
[TD] 0.18 [/TD]
[TD] 0.87 [/TD]
[TD] 0.19 [/TD]
[TD] 0.37 [/TD]
[TD][/TD]
[TD] 0.14 [/TD]
[TD] (0.81)[/TD]
[TD] 0.58 [/TD]
[TD] 0.09 [/TD]
[TD][/TD]
[TD][/TD]
[TD]Show[/TD]
[/TR]
[TR]
[TD]Project 2[/TD]
[TD] 0.97 [/TD]
[TD] 0.30 [/TD]
[TD] 0.29 [/TD]
[TD] 0.41 [/TD]
[TD] 0.97 [/TD]
[TD][/TD]
[TD] 0.60 [/TD]
[TD] 0.24 [/TD]
[TD] 0.39 [/TD]
[TD] 0.82 [/TD]
[TD] 0.66 [/TD]
[TD][/TD]
[TD] 0.31 [/TD]
[TD] (0.05)[/TD]
[TD] (0.03)[/TD]
[TD] (0.15)[/TD]
[TD][/TD]
[TD][/TD]
[TD]Show[/TD]
[/TR]
[TR]
[TD]Project 3[/TD]
[TD] 0.86 [/TD]
[TD] 0.80 [/TD]
[TD] 0.68 [/TD]
[TD] 0.94 [/TD]
[TD] 0.01 [/TD]
[TD][/TD]
[TD] 0.47 [/TD]
[TD] 0.64 [/TD]
[TD] 0.67 [/TD]
[TD] 0.42 [/TD]
[TD] 0.85 [/TD]
[TD][/TD]
[TD] (0.33)[/TD]
[TD] (0.04)[/TD]
[TD] (0.27)[/TD]
[TD] 0.41 [/TD]
[TD][/TD]
[TD][/TD]
[TD]Show[/TD]
[/TR]
[TR]
[TD]Project 4[/TD]
[TD] 0.12 [/TD]
[TD] 0.52 [/TD]
[TD] 0.67 [/TD]
[TD] 0.90 [/TD]
[TD] 0.30 [/TD]
[TD][/TD]
[TD] 0.55 [/TD]
[TD] 0.88 [/TD]
[TD] 0.05 [/TD]
[TD] 0.24 [/TD]
[TD] 0.31 [/TD]
[TD][/TD]
[TD] 0.02 [/TD]
[TD] 0.21 [/TD]
[TD] (0.84)[/TD]
[TD] (0.06)[/TD]
[TD][/TD]
[TD][/TD]
[TD]Show[/TD]
[/TR]
[TR]
[TD]Project 5[/TD]
[TD] 0.36 [/TD]
[TD] 0.47 [/TD]
[TD] 0.04 [/TD]
[TD] 0.62 [/TD]
[TD] 0.96 [/TD]
[TD][/TD]
[TD] 0.50 [/TD]
[TD] 0.38 [/TD]
[TD] 0.36 [/TD]
[TD] 0.59 [/TD]
[TD] 0.80 [/TD]
[TD][/TD]
[TD] 0.03 [/TD]
[TD] 0.34 [/TD]
[TD] (0.26)[/TD]
[TD] (0.38)[/TD]
[TD][/TD]
[TD][/TD]
[TD]Show[/TD]
[/TR]
[TR]
[TD]Project 6[/TD]
[TD] 0.74 [/TD]
[TD] 0.54 [/TD]
[TD] 0.81 [/TD]
[TD] 0.52 [/TD]
[TD] 0.09 [/TD]
[TD][/TD]
[TD] 0.94 [/TD]
[TD] 0.91 [/TD]
[TD] 0.09 [/TD]
[TD] 0.54 [/TD]
[TD] 0.03 [/TD]
[TD][/TD]
[TD] 0.40 [/TD]
[TD] 0.11 [/TD]
[TD] (0.43)[/TD]
[TD] 0.45 [/TD]
[TD][/TD]
[TD][/TD]
[TD]Show[/TD]
[/TR]
[TR]
[TD]Project 7[/TD]
[TD] 0.77 [/TD]
[TD] 0.52 [/TD]
[TD] 0.74 [/TD]
[TD] 0.33 [/TD]
[TD] 0.02 [/TD]
[TD][/TD]
[TD] 0.16 [/TD]
[TD] 0.06 [/TD]
[TD] 0.92 [/TD]
[TD] 0.27 [/TD]
[TD] 0.75 [/TD]
[TD][/TD]
[TD] (0.36)[/TD]
[TD] (0.68)[/TD]
[TD] 0.58 [/TD]
[TD] 0.26 [/TD]
[TD][/TD]
[TD][/TD]
[TD]Show[/TD]
[/TR]
[TR]
[TD]Project 8[/TD]
[TD] 0.70 [/TD]
[TD] 0.66 [/TD]
[TD] 0.68 [/TD]
[TD] 0.74 [/TD]
[TD] 0.71 [/TD]
[TD][/TD]
[TD] 0.02 [/TD]
[TD] 0.87 [/TD]
[TD] 0.51 [/TD]
[TD] 0.18 [/TD]
[TD] 0.07 [/TD]
[TD][/TD]
[TD] (0.64)[/TD]
[TD] 0.19 [/TD]
[TD] (0.23)[/TD]
[TD] (0.53)[/TD]
[TD][/TD]
[TD][/TD]
[TD]Show[/TD]
[/TR]
[TR]
[TD]Project 9[/TD]
[TD] 0.39 [/TD]
[TD] 0.96 [/TD]
[TD] 0.83 [/TD]
[TD] 0.04 [/TD]
[TD] 0.19 [/TD]
[TD][/TD]
[TD] 0.12 [/TD]
[TD] 0.76 [/TD]
[TD] 0.76 [/TD]
[TD] 0.66 [/TD]
[TD] 0.27 [/TD]
[TD][/TD]
[TD] (0.83)[/TD]
[TD] (0.07)[/TD]
[TD] 0.72 [/TD]
[TD] 0.47 [/TD]
[TD][/TD]
[TD][/TD]
[TD]Show[/TD]
[/TR]
[TR]
[TD]Project 10[/TD]
[TD] 0.05 [/TD]
[TD] 0.94 [/TD]
[TD] 0.02 [/TD]
[TD] 0.35 [/TD]
[TD] 0.04 [/TD]
[TD][/TD]
[TD] 0.44 [/TD]
[TD] 0.85 [/TD]
[TD] 0.16 [/TD]
[TD] 0.39 [/TD]
[TD] 0.97 [/TD]
[TD][/TD]
[TD] (0.50)[/TD]
[TD] 0.83 [/TD]
[TD] (0.19)[/TD]
[TD] 0.35 [/TD]
[TD][/TD]
[TD][/TD]
[TD]Show[/TD]
[/TR]
[TR]
[TD]Project 11[/TD]
[TD] 0.34 [/TD]
[TD] 0.29 [/TD]
[TD] 0.98 [/TD]
[TD] 0.60 [/TD]
[TD] 0.38 [/TD]
[TD][/TD]
[TD] 0.65 [/TD]
[TD] 0.69 [/TD]
[TD] 0.56 [/TD]
[TD] 0.63 [/TD]
[TD] 0.64 [/TD]
[TD][/TD]
[TD] 0.37 [/TD]
[TD] (0.29)[/TD]
[TD] (0.05)[/TD]
[TD] 0.25 [/TD]
[TD][/TD]
[TD][/TD]
[TD]Show[/TD]
[/TR]
</tbody><colgroup><col><col span="19"></colgroup>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[boweryreserve]

I just thought of some more information that may provide some insight into what I'm trying to do. The print range will be A1:T15. But if someone enters data in rows 16 and 17, I want the macro to change the print range to A1:T17. Column T will automatically say "Show" if data is populated in the row. So I need the macro to somehow change the end of the print range to the maximum row (always column T) where the column T(row number) = "Show". Thanks for your help.