jasonfhaught
New Member
- Joined
- Mar 30, 2022
- Messages
- 3
- Office Version
- 365
I found a bit of code that works but would like to use without using the inputbox type 8
Set rPrintArea = Application.InputBox(Prompt:="Use Mouse to select area to Print.", Title:="Select Print Area", Type:=8)
I want to be able to do is Set rPrintArea = Range("A1:C20") but I have not yet been able to make it work.
Could you help me and explain what is going on with the statement
Set rPrintArea = Application.InputBox(Prompt:="Use Mouse to select area to Print.", Title:="Select Print Area", Type:=8)
I want to be able to do is Set rPrintArea = Range("A1:C20") but I have not yet been able to make it work.
Could you help me and explain what is going on with the statement