Visual Basic to reference value in Excel cell

  • Thread starter Thread starter Raymond
  • Start date Start date
R

Raymond

I have a small program, and in a particular cell, I ask a
user to enter the number of copies they want printed when
they push the button linked to the printpages macro I
made. In the macro I want to change the "Copies:=1" so
that rather than a 1, it will reference the value of the
cell they entered the number of copies desired. I tried

ActiveWindow.SelectedSheets.PrintOut Copies:=Cells
([g], [22]), Collate:=True Range("E4").Select

But that didnt work. I dont know much about VB or how to
use it in conjunction with Excel, but anyone who can help
me fix this is greatly appreciated!

Ray
 
Back
Top