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 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?
    • See if you can thermal epoxy a heatsink or two onto it?
    • The other problem was one of those "oh shit we are going to die moments". Basically the high spec Q50s have a full electric steering rack, and the povo ones had a regular hydraulic rack with an electric pump.  So couple of laps into session 5 as I came into turn 2 (big run off now, happily), the dash turned into a christmas tree and the steering became super heavy and I went well off. I assumed it was a tyre failure so limped to the pits, but everything was OK. But....the master warning light was still on so I checked the DTCs and saw – C13E6 “Heat Protection”. Yes, that bloody steering rack computer sitting where the oil cooler should be has its own sensors and error logic, and decided I was using the steering wheel too much. I really appreciated the helpful information in the manual (my bold) POSSIBLE CAUSE • Continuing the overloading steering (Sports driving in the circuit etc,) “DATA MONITOR” >> “C/M TEMPERATURE”. The rise of steering force motor internal temperature caused the protection function to operate. This is not a system malfunction. INSPECTION END So, basically the electric motor in the steering rack got to 150c, and it decided to shut down without warning for my safety. Didn't feel safe. Short term I'll see if I can duct some air to that motor (the engine bay is sealed pretty tight). Long term, depending on how often this happens, I'll look into swapping the povo spec electric/hydraulic rack in. While the rack should be fine the power supply to the pump will be a pain and might be best to deal with it when I add a PDM.
    • And finally, 2 problems I really need to sort.  Firstly as Matt said the auto trans is not happy as it gets hot - I couldn't log the temps but the gauge showed 90o. On the first day I took it out back in Feb, because the coolant was getting hot I never got to any auto trans issues; but on this day by late session 3 and then really clearly in 4 and 5 as it got hotter it just would not shift up. You can hear the issue really clearly at 12:55 and 16:20 on the vid. So the good news is, literally this week Ecutek finally released tuning for the jatco 7 speed. I'll have a chat to Racebox and see what they can do electrically to keep it cooler and to get the gears, if anything. That will likely take some R&D and can only really happen on track as it never gets even warm with road use. I've also picked up some eye wateringly expensive Redline D6 ATF to try, it had the highest viscosity I could find at 100o so we will see if that helps (just waiting for some oil pan gaskets so I can change it properly). If neither of those work I need to remove the coolant/trans interwarmer and the radiator cooler and go to an external cooler....somewhere.....(goodbye washer reservoir?), and if that fails give up on this mad idea and wait for Nissan to release the manual 400R
×
×
  • Create New...