Visual Basic to reference value in Excel cell
 

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

Visual Basic to reference value in Excel cell
 

Ray try using:
Range("G22").value or Cells(7,22).value

-----Original Message-----
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
.