Run-time Error '9'

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Run-time Error '9': Subscript out of range

This error keeps appearing when I try to set up the print function command
button. I have used the same exact code on other worksheets in the same
workbook (I just changed the worksheet name) and have not had any problems.
The first line of the code is highlighted when I debug.

Private Sub CommandButton1_Click()
Sheets("Application").PageSetup.PrintArea =
Sheets("Application").Range("$a$1:$j$39").Address
Sheets("Application").PrintOut Copies:=1
End Sub
 
Maybe you don't have a sheet called Application. Check that it doesn't have
leading/trailing space(s).

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code to format cells on several worksheets 2
combind print copy amount 1
? Object What object 1
Excel VBA - Problem with Closing Print Preview 0
Run time error message???....Help!! 12
Error Message - Macro to Unlink MS Queries from Workbook 0
macro add 10
Error using a macro to print multiple pages. 2

Back
Top