Try something like

Dim Ndx As Long
For Ndx = Worksheets("Front").Index To Worksheets("End").Index
' do something with Worksheets(Ndx)
Next Ndx


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"ewan7279" wrote in message
...
Hi,

Can anyone suggest how I can loop between two sheets within a
workbook
please? I do not know how many sheets there will be in the
workbook, but I
do know the names of two of them. It is between these two
sheets ("FRONT"
and "END") that I wish to loop and paste data into.

Any advice greatly appreciated.

Thanks,

Ewan.