CODEWITHSUNDEEP
excelvba
pokemon_Man
pokemon_Man

Reputation: 902

How to select the range of the print area of worksheet?

I have a worksheet that I manually set the print area of the working area. What I want to do is select the range of the print area and do a spell check. 

ActiveSheet.UsedRange.Select --> this selects ALL used range that is also not in the print area.

Any ideas?

Upvotes: 0

Views: 4698

Answers (1)

Scott Craner
Scott Craner

Reputation: 152585

Use this:

Activesheet.Range(ActiveSheet.PageSetup.PrintArea).Select

One note, though you asked how to select the range, one should avoid using select whenever possible and just do what you want to do.

Activesheet.Range(ActiveSheet.PageSetup.PrintArea).CheckSpelling

Upvotes: 4

Related Questions