Inner West Crew Whoretown (toowong/st Lucia/kenmore/indooroopilly And Sometimes Sunnybank?)

[astrotristan]

Bahaahahahahahahahaahah*takes breath*ahahahahaahahahahahaah

yeeh it was hard for me to type that i was rofling so much

[Smity42]

brandon you only need to type it once then ppl will stop asking you about it

@colin good luck with it then mate

[Brandon]

im in my own personal recession -

i need this cheque to hurry the f**k up and go thru so i cant pick up the 180

i think i want 17*9.5 +15 black driftdeks

WTF the bank doing? Talk about efficiency.

[astrotristan]

WTF the bank doing? Talk about efficiency.

yeeh i kno hey

i used the "not acceptable line"

got put thru to 2 different bank managers, and guess waht? my funds have now cleared

Edited September 25, 2009 by astrotristan2

[astrotristan]

lolz i just linked the whores in the events thread to this one

1,000 pages here we come!

[Brandon]

Josh we started a fight club at the car wash but obviously Brandon wasn't listening to the rules. Rule 1: You don't talk about fight club!

DONE! Now stop asking me

[Nismo_Boy]

wtf is this shit

[Brandon]

Something more epic than your granny rage

[Nismo_Boy]

Something more epic than your granny rage

anyone drop an ice cream?

[Brandon]

Else

WSname = ActiveCell.Value

Set wsheet = Worksheets(WSname)

If wsheet Is Nothing Then

Set TemplateSheet = Worksheets("Template")

TemplateSheet.Copy after:=Sheets(1)

ActiveSheet.Name = WSname

ActiveSheet.Range("C3").Value = WSname

ActiveSheet.Range("C4").Value = ""

Call CopyData

Else

Call CopyData

End If

Anyone can solve this for me?

WSname = ActiveCell.Value ====> this shit works

Set wsheet = Worksheets(WSname) ====> but this doesnt.

Apparently it doesnt work because that sheet doesnt exist. Maybe I can use this error (on error goto) to skip to the next step which I want to do??

I'm trying to check if the sheet exist or not. And ths sheet that I'm check is variable.

[Beelzebub89]

Josh we started a fight club at the car wash but obviously Brandon wasn't listening to the rules. Rule 1: You don't talk about fight club!

[Brandon]

No ice creams from me. Micks' a champ for fixing that Evo up.

[Nismo_Boy]

Josh we started a fight club at the car wash but obviously Brandon wasn't listening to the rules. Rule 1: You don't talk about fight club!

I might come, one day. Maybe. Haha

[Nismo_Boy]

Else

WSname = ActiveCell.Value

Set wsheet = Worksheets(WSname)

If wsheet Is Nothing Then

Set TemplateSheet = Worksheets("Template")

TemplateSheet.Copy after:=Sheets(1)

ActiveSheet.Name = WSname

ActiveSheet.Range("C3").Value = WSname

ActiveSheet.Range("C4").Value = ""

Call CopyData

Else

Call CopyData

End If

Anyone can solve this for me?

WSname = ActiveCell.Value ====> this shit works

Set wsheet = Worksheets(WSname) ====> but this doesnt.

Apparently it doesnt work because that sheet doesnt exist. Maybe I can use this error (on error goto) to skip to the next step which I want to do??

I'm trying to check if the sheet exist or not. And ths sheet that I'm check is variable.

x zero.

[Smity42]

Brandon, does it not work all the time, or only not work if the sheet doesnt exist?

[Nismo_Boy]

Help??

http://www.skylinesaustralia.com/forums/Co...03#entry4846103

[Brandon]

Brandon, does it not work all the time, or only not work if the sheet doesnt exist?

The on error goto WORKED! That bit on Set wsheet = Worksheets(WSname), only work if the sheet exist. So I dont know how the f**k you're suppose to check a variable sheetname. It'll only work if you wanna check a pre-specified sheetname.

Now I've got another problem of making the sheet active again because of that. This macro shit is fun and time flies when you're troubleshooting

[Beelzebub89]

No ice creams from me. Micks' a champ for fixing that Evo up.

Lol lobster back piping ftw?

I might come, one day. Maybe. Haha

Bring it on Joshy. No hair pulling or scratchin though

x zero.

I believe its /zero.

[Smity42]

excel macros are sh!t coz they are still based on VB6 which came out about when i was in primary school :S

programming languages have come so far since then but macros are still stuck in the stone ages

to make the sheet active wsheet.activate() or something like that should do it.

[Smity42]

f*ck yeah, i just got a big package, it's my "shipment" from mexico

sat/sun night touge anyone?