Visual Basic to reference value in Excel cell

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
 

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

VB Script reference cells for in current table? 1
Word macro that can call cells out of Excel for a find and replace 0
A simple printing pages depending on cell value 3
Pasting a cell into bookmarked table from excel vba 1
Display formulae as values of each cell reference 7
Macro to Combine Data from Multiple Sheets with Cell References 4
Arrays and scattered cell values or another way? 16
macro to set bottom and top values for randbetween 6

Top