try this
for each ws in worksheets
if left(ws.name,3)="buy" then runmycode
next ws

--
Don Guillett
SalesAid Software

"SUNIL" wrote in message
...
how can a piece of code be run on every sheet whose name that begins with
"buy", in a particular workbook ?

Thanks in anticipation

Sunil