View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Lonnie M. Lonnie M. is offline
external usenet poster
 
Posts: 184
Default LOOP BETWEEN "FRONT" AND "END" SHEETS?

Hi, if I understand you, each sheet between "Front" and "End" you wish
to insert some data.

Dim WS As Worksheet
For Each WS In Worksheets
If WS.Name < "Front" OR WS.Name < "End"
'Code to insert data
End If
Next

Let me know if this is not what you were aiming to do. HTH--Lonnie M.