Help with printing macro

[Tor164]

Hi
I need some help with a macro I currently have. I have 2 sheets - one with the data and one with the summary (which summariuses the data from the other sheet). I have a print macro but wanted to modify this for a particular range of cells.

I am a beginning so would be grateful for any help

This is what I have:
Sub Print_statement()

' Print_list Macro
' Macro recorded 29/09/2011 by Tor 164
'
Dim ws As Worksheet
Dim i As Long

Set ws = Sheets("2013-2014 Benefit choices")

For i = 1 To ws.Cells(Rows.Count, "C").End(xlUp).Row
With Sheets("stmnt")
.Range("C3").Value = ws.Cells(i, "C").Value
.PrintPreview '
End With
Next i


End Sub

[HaHoBe]

Hi, Tor164,

please wrap your procedure with code.tags like requested in Forum Rule #3 and tell us about the range: will it influence the area to which is posted or just limit the area from Sheet "2013-2014 Benefit choices"?

Ciao,
Holger

[Tor164]

Hi Holger
Many thanks for replying to this. I think I hust want to limit the area from Sheet "2013-2014" so it only picks up rows 1 through to 100 for example.

I hope this makes sense. I think I have put the code correctly underneath

Tor

Please Login or Register  to view this content.

[HaHoBe]

Hi, Tor,

I thought of adding tags to the opening post...

Maybe like this:

Please Login or Register  to view this content.

Ciao,
Holger