melewie
Board Regular
- Joined
- Nov 21, 2008
- Messages
- 188
- Office Version
- 365
- Platform
- Windows
Hi All,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
ffice
ffice" /><o
></o
>
<o
></o
>
First off I know there has been a quite a few post about this but I am really struggling with it (not sure if its because its Monday or I have the coding skills of a drunken chimp)<o
></o
>
<o
></o
>
I am trying to create a new sheet if the sheet already exists then delete it and create a new sheet of the same name.<o
></o
>
<o
></o
>
Worksheets.Add.Name = "Missing Data"<o
></o
>
<o
></o
>
If error delete the bloody thing and create a new one!!<o
></o
>
<o
></o
>
Trying to make this generic so it could used 26 times (with different sheet names every time) so I am trying to create a sub I can call to do this.<o
></o
>
<o
></o
>
Worksheets.Add.Name = "Missing Data"<o
></o
>
<o
></o
>
If error call answer<o
></o
>
<o
></o
>
Any help would be greatly appreciated




<o


First off I know there has been a quite a few post about this but I am really struggling with it (not sure if its because its Monday or I have the coding skills of a drunken chimp)<o


<o


I am trying to create a new sheet if the sheet already exists then delete it and create a new sheet of the same name.<o


<o


Worksheets.Add.Name = "Missing Data"<o


<o


If error delete the bloody thing and create a new one!!<o


<o


Trying to make this generic so it could used 26 times (with different sheet names every time) so I am trying to create a sub I can call to do this.<o


<o


Worksheets.Add.Name = "Missing Data"<o


<o


If error call answer<o


<o


Any help would be greatly appreciated