See this page Ozzie
http://www.rondebruin.nl/copy5.htm

You must use this example
http://www.rondebruin.nl/copy5.htm#all


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Ozzie via OfficeKB.com" <u18021@uwe wrote in message news:5bd325a636d6a@uwe...
Guys,

I have a sheet of data, with many lines, that I want to seperate out onto
individual tabs within the same workbook, and to re-name those tabs.

ie within the master sheet their will be data for Area1, Area2, Area3 etc and
what I need is Sheet1 = Area1 - tab re-named Area1, Sheet2 = Area2 - tab re-
named to Area2 and so on.

Anybody know how to write the code to do this??

Many thanks for any help

Kind Regards

David

--
Message posted via http://www.officekb.com