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

    • Ahhh, I need the whole head unit. I definitely needed to roll back through and review your setup, ha ha! Neat setup they have going on. I just need a full double din head unit. But I want good and responsive. I might have to review what the likes of pioneer have out these days.
    • Ok so after much research and talking with knowledgeable people I've got my turbo conversion done and it's all running great other than 1 small issue.  Car has remained auto with the na auto and tcm, I've used a stagea ecu with. NIstune board and everything is great other than my gear selection on the dash. It illuminates park, reverse, neutral, 3rd and 2nd. But nothing drive or what gear your in when you pop it into tiptronic.  I'm sure there is may e 1 wire in the ecu plug I need to move to rectify this. Dose anyone here have any ideas?   Cheers guys
    • Sorry I haven't been following all the detail, so you may have tried this. Does it idle with the tiniest bit of throttle you can add? You've mentioned the IACV, does it have an AAC valve and have you adjusted it at all (ie, screw the idle adjust screw all the way in, then back it out a couple of turns until idle is stable)?
    • My bad, I unplugged the one underlined in red instead of yellow before. With the car started, after unplugging the IACV (the one underlined in yellow), it idled at around 400/500 for 3 seconds before stalling. Attempting to start the car without the IACV will not start the car.   It does stutter and sputter for around 5 seconds before dying. However, immediately after starting it, you can already hear some slight sputters from the exhaust.   It won't start with the AFM unplugged. If it is when the car has already started, it stalls in a few seconds.   Yesterday, I did take some logs using Nistune of 3 scenarios. Car idling till it stalls Car idling and unplugging the IACV Car idling and removing the AFM I also have some previous logs of when the Car is idling till it stalls and when driving and it cuts. I am not really knowledgeable enough to understand what to look for. After every test, car idles rougher and rougher, until I have to stop. It will be fine the day after.
    • There is no difference between a 17x8 and an 18x8. The total diameter of the tyre needs to remain +/- the same (so you don't mess up the gearing, speedo reading, and clearance when turning front wheels..... so you just need to use a lower profile tyre on th 18 than you do on the 17. /rocket surgery.
×
×
  • Create New...