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

    • @666DAN sorry to bring you and old thread.     I've got my de+t 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 when selected . But nothing when in  drive or what gear your in when you pop it into tiptronic. I'm sure there is maybe 1 wire in the ecu plug I need to move to rectify this. Do ya have any ideas?     Cheers man
    • Well I recently changed my rear axles and was thinking if I bumped anything, I have been driving the car for a while now though... But it has been raining today so everything is wet under the wheel arches. Brakes feel fine and can't hear any of the metal screamers, I had a squeak coming from one of the handbrake drums but that seems to have gone away a while ago. I was going down a hill when it lit up and I did feel the abs bite for a second and question why it did it?
    • Correct. Um. I dunno. I haven't cared enough about the way that the NA cars work to know for sure. But..... The 33/34 turbo manual cars have an electronic speed sensor in the gearbox that outputs a +/- (ie, sawtooth AC) voltage signal. That is connected to the speedo. The speedo then outputs a 0-5v square wave (ie, PWM) signal that the ECU (and any other CU on the bus) sees. The speed sensor is NOT directly connected to the ECU. So here's the problem. Your new ECU expects to see the PWM signal, but must somehow be getting a direct signal from the diff speed sensor. Which would suggest that the wiring of the NA car is not the same as the turbo cars. I think you will need to spend some time with (hopefully the wiring diagram for the car) and a multimeter to see what is connected to what. Then, presuming I am correct**, you would then want to separate the ECU speed signal input from the rest of the car's wiring, and probably either buy a speed signal converter, or build one using an arduino (or similar). That would take in the speed sensor signal and output a scaled (and suitably rearranged) signal for the ECU. ** We shouldn't presume that I am correct here, because there might be something else crazy going on. I don't think you could convert the speedo to be fed from the gearbox sensor, because the pulse rate from that sensor is probably different to the diff sensor and then the speedo would read wrongly. And this also wouldn't fix the ECU's problem either, because the ECU doesn't want to see the gearbox signal direct either (assuming that they are all on the same wiring, for some odd NA related reason, see above caveat!) Does this help? Probably not. Can you make it work? Almost certainly. With the above work. You should buy a handheld oscilloscope from Aliexpress so that you can view these signals directly. Connect up the probes and drive the car. Show photos of the screen when drving at known speeds and connected to different places, and we'll see what we can learn about it.
    • Assuming your brake pads are not worn right down, I'd add a little brake fluid. Is there any sign of a brake fluid leak?
    • Hello all,  I need of some help. On my drive home my handbrake light lit up and started flashing. When I got home I checked my handbrake sensor under the centre console and nothing seemed out of the ordinary. I have scanned my car via the consult port, no codes shown. Checked my brake fluid as well which is half full. Tried unplugging the brake master but it didn't change anything. Thoughts on what it could be? The master float doesn't seem to be stuck. My car is an 1998 ER34 sedan GT. No hicas but has ABS Photos below 👇🏾 
×
×
  • Create New...