Can you tell me what is wrong with this print command?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • JanClaire
    New Member
    • May 2012
    • 1

    Can you tell me what is wrong with this print command?

    Private Sub CommandButton1_ Click()

    'Sub PrintSPM()

    Sheets("SD Measurement").R ange("A1:H28"). PrintOut Copies:=1
    Sheets("Menu"). Select
    Range("D16").Se lect

    End Sub
  • Killer42
    Recognized Expert Expert
    • Oct 2006
    • 8429

    #2
    Can you give us more info on the situation? For instance, why do you think it's wrong? Does it produce an error message? If so, please provide details.

    When I create a worksheet called "SD Measurement" and paste your PrintOut command into the immediate window, it appears to work.

    Comment

    Working...