Hi everyone, hoping someone will be able to lend some knowledge.
I'm trying to devise a looping macro to mass print based off a list of numbers pasted in by the user. Essentially I want to have a highlighted print area where the user can paste in the numbers click the button and go. I had set up something similar a few weeks back that worked fine (or at least no one has told me otherwise since I set it up).
For this one I started by recording the copy/paste/print of the first number and than went into modify it into a loop that is below.
Sub BulkPrint()
'
' BulkPrint Macro
'
'
For i = 50 To 250
If ActiveSheet.Cells(i, 1).Value = "" Then Exit Sub
Cells(i, 1).Select
Selection.Copy
Cells(2, 2).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("CFS Business Review").Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True, _
IgnorePrintAreas:=False
Sheets("Select CISID").Select
Next i
End Sub
Now whenever I try to run the macro I get the error of "Compile error: cannot find project or library"
Any thoughts??? I'm also trying to sift my way through the Excel built in help but I find the folks on here to be much more informative/helpful/understandable.
Thanks in advance!
~James Cameron
Bookmarks