Jump to content
SAU Community

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


Recommended Posts

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.

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 :cool::)

Edited by astrotristan2
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

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.

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!

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

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.

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

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 :cool:

x zero.

I believe its /zero.

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.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now



  • Latest Posts

    • Kinda glad I never got to this ..    https://www.facebook.com/groups/1483859159195077
    • @GTSBoy This method was able to get readings of -10 to -2, so it looks like its monitoring.  Now I need to figure out why the vacuum on the line provided isn't alternating with manifold pressure.  I went with 2 lines that an RB25 tuner recommended but I'll get a longer hose and try directly off the back of the manifold.  He may have been used to OEM intake setups while I have a DBW setup that removed the MAF and IACV.  
    • I work at a car detailing and tinting shop called Quark which gets all manner of German cars in usually (mainly due to a contract with Mercedes Benz Kita Osaka, BMW Nishinomiya and others) but every once in a while something special comes in, like a fully restored 1972 HS30 Nissan Fairlady 240ZG... The shop owner had immediately started applying film to the windows as soon as it was in the shop so the interior was completely covered in towels and plastic sheets. But I could get a few photos of the engine bay which was restored like new. Such an amazing car to see in pristine condition in Japan these days.  
    • Was going to say the car pulls up nicely everywhere, especially going into that last long right hander before the main straight. Looks like a lot of fun.
    • Hey Dave, welcome aboard! Good to see another soon-to-be Stagea owner here. The wagons are awesome — plenty of space, still got that Skyline DNA, and loads of potential if you’re into mods. Definitely post up pics when you get it, everyone here loves seeing new builds. What model/year are you looking at?
×
×
  • Create New...