Hi Ewan7279,
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.
Dim oSh as worksheet
Dim bFirstPassed as Boolean
For Each oSh in Thisworkbook.Worksheets
If bFirstPassed Then
'Do your thing!
End If
If oSh.Name="FRONT" Then bFirstPassed=True
If oSh.Name="END" Then Exit For
Next
Regards,
Jan Karel Pieterse
Excel MVP
www.jkp-ads.com