Macro Help

[ctc005]

 Range("A1:F93").Select

If I have that code and I want to command that it highlight "n" number of columns additionally how do I do so? The number of columns in addition to highlight is located in cell D5. In the example I am running I want to select A1:J93 so the number is cell D5 is 4. I can also be flexible and make cell D5 be equal to 10, which would be the total number of columns to highlight. This is part of a print function I'm trying to write. Any and all help appreciated.

 

[goldfish]

Range("A1:F93").Resize(,4).Select

Will select 4 columns in total, so if you want to select the number you wish do something like

Range("A1:F93").Resize(, Range("A1:F93").Columns.Count + Range("D5").Value).Select

HTH,

~Gold Fish