Data Validation listing

[OAM]

Someone helped me come up with the macro below to allow me to print 100 timesheets from a Validation list by using a macro. This macro works well but I forgot to mention that the source of the validation list is on another sheet and I do not know how to get the code to reference the information on the other sheet.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
Can someone help me make this work?


Sub PrintAll()
For Each cell In Range("V47:V132")
Range("F2") = cell
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Next cell
End Sub

 

[dafan]

If you want to refer to cell A1 on sheet 1, this would be your code:

Sheets("Sheet1").Range("A1")

Hopefully you can adapt this to your own problem as you didn't tell us the name of your sheet or which cell on which sheet you want to refer to.

 

[aca_041]

sheets("insert the sheet name here").Range("V47:V132")

 

[OAM]

Thank you for all your help it worked!