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

    • Was there ever a model of the Stagea m35 that didnt have a badge on the grill? I thought I saw that somewhere, some aero edition or something? I cant find it again? davemoto
    • Its a 2002 vr-x four VQ25DET, silver. Coil overs, lowered, polished alloys and sport exhaust. Bit of a project, was sitting in a shed for a while but runs and drives great.
    • I wasn’t able to replicate the sound anymore. It was a one time sound so maybe it was just coincidence but it was like small pebbles being dropped in a coke can.   should I try cleaning the MAF? It could be it’s functioning but dirty? I don’t know.
    • Update 4: Hi all. The car drives again! Haven't driven for long, only to store it in the garage again, but the test drive was successful. The coolant and oil leaks seem to be fixed for now. Temps on the engine were also very good, while moving I never even saw 80C water during the approx. 30 minute drive. Ate up all the coolant in the reservoir though so will have to fill that even more when I go to the car next time. One thing that pisses me off is that the RPM gauge is still f**ked, I even resoldered the board twice and used copper paste on the silly screws that are used as connections. Next time I take it out I'll take apart the board and fit new components, I'll see if I can get a replacement IC for it.  I have an appointment set for 22nd of September for the engine tune to 370hp. Alignment also still needs to be done. My hope is that I can get all the legal stuff over with by the end of this season. Anyone of you have advice regarding intercoolers? Currently there is an APEXI core fitted, one of those weird hybrid ones, 600x270x76. I don't think it's bad but it's not new and now I still have the chance to change it now to legally include it in the paperwork. Only issue is that the only options that would arrive in time are a HKS Type R intercooler or generic Ebay spec intercoolers comparable to a JustJap one. Ideally I'd order a Plazmaman but it takes over a month to receive which would mean making the car legal has to wait until next season. Would love to hear some input on this. Same story for my injectors, the previous owner was a nunce and put ID 1050x on the engine. They work but are obviously not ideal at "normal" power levels. But I don't see a reason to change them unless the tuner says it's necessary. I read online before buying a different exhaust that the top secret style rear diffusers won't fit due to the size of the rear resonators. My buddy and I made it work by slightly "adjusting the shape" of the mounting bracket and making some spacers out of 3d print for the mounting bolts. Fits like a charm. Just putting this here in case someone has this problem. Even the hefty HKS Silent Hi Power rear can fits without hitting anything.
    • Well they got my money but they are not getting my gearbox ! 
×
×
  • Create New...