who here is good at Excel macros?

[OMGWTFBBQ]

I need to create a new tab and I need to do it programmatically - anyone here know how to do that?

I can't even find it on "the net".

 

[Mandinka2]

Pretty sure I can do that for u , hit me up on MSN man

 

[Bullit]

You fucking suck at internetting.

 

[Mandinka2]

Here is the VBA code - pretty easy :

Sub Create_New_Tab()
'
' Create_New_Tab Macro
' Macro recorded 27/01/2004 by Fat Shit'

'
Sheets.Add
Sheets("Sheet4").Select
Sheets("Sheet4").Name = "Shits&Giggles"
End Sub

"Sheet4" is the added sheet name , u can write something to count the number of sheets currently there and then u will know what the name of the new sheet is if u need to change it. Sheets.Count will give the integer number to you.

 

[OMGWTFBBQ]

Pretty sure I can do that for u , hit me up on MSN man

I don't have MSN - I have Yahoo and AIM.

I think I was looking under "tab" and should be looking to create a new "sheet" instead.

Oh, as I'm scrolling this I see you have already posted something - thank you so much! I'll check this out.

 

[Mandinka2]

I don't have MSN - I have Yahoo and AIM.

I think I was looking under "tab" and should be looking to create a new "sheet" instead.

Oh, as I'm scrolling this I see you have already posted something - thank you so much! I'll check this out.

[email protected]

 

[tiger88]

LOL @ THIS THREAD

 

[Becoming]

click on "Help" then lookup "create macros" like everyone else....

 

[OMGWTFBBQ]

click on "Help" then lookup "create macros" like everyone else....

The help on this doesn't work unfortunately, but that was the first place I tried.

then I did a search for "I am pathetic" and all I got were pictures of my feet.

 

[Y_lifter]

Well ?

Did the VB work ?

Do you owe Mandinka2 some Man Loving ?

 

[alien amp pharm]

Do you owe Mandinka2 some Man Loving ?

WHO DOESN'T!?!?!!!

 

[Y_lifter]

WHO DOESN'T!?!?!!!

Raina ?
Vix?

 

[OMGWTFBBQ]

Well ?

Did the VB work ?

Do you owe Mandinka2 some Man Loving ?

It should work - I went to bed fairly soon after that last night and today at work was far too busy to get a chance to work on it.

So yeah, I guess someone is gonna be the giver and someone is the taker.