On Thu, 19 Aug 2004 08:47:21 +0100, dht wrote:

I think the problem lies more with my poor coding than Excel.

Before this sheet breaks down it is suppose to create a sheet, and paste
data from another sheet using location data.

The problem lies in something to do with that I have 19 seperate pieces of
code. Rather than one standard that is repeated 19 times with the basic
information (section number changing).

[big snip]

This code is run from another macro. which application.run"Section_1" is
used.
What I don't know what to do is tell VBA to create sheets 1 - 19 using the
prefix of 1 to 19 create sheets relating to this.


For x = 1 to 19
ActiveSheet.Name = "Section " & CStr(x)
'your code...
Next

Does that help?
--
auric underscore underscore at hotmail dot com
*****
Go ahead and steal my sig. I probably stole it myself.