Jump to content
SAU Community

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

funkymonkey

By funkymonkey,
in Queensland

 Share

Recommended Posts

  • Replies 37.7k
  • Created
  • Last Reply

Top Posters In This Topic

  • Smity42

    6056

  • Isola

    4161

  • astrotristan

    3047

  • Beelzebub89

    2843

Popular Days

Top Posters In This Topic

Popular Days

Popular Posts

FineLine
FineLine

Are you allowed to drive a turb on p plates. ?

FineLine
FineLine

They do indeed mate. doesnt matter where you live these days, if its a line its a target. Mine are kept under lock and key.

FineLine
FineLine

Yes Yes! It truly is....If you like long delays and the worst farken traffic in the state.

Posted Images

Brandon Veteran

Brandon

Posted
Posted
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.

astrotristan Grand Master

astrotristan

Posted
Posted (edited)
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
Brandon Veteran

Brandon

Posted
Posted
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

Brandon Veteran

Brandon

Posted
Posted

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.

Beelzebub89 Grand Master

Beelzebub89

Posted
Posted

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!

Nismo_Boy Grand Master

Nismo_Boy

Posted
Posted
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

Nismo_Boy Grand Master

Nismo_Boy

Posted
Posted
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 Veteran

Brandon

Posted
Posted
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

Beelzebub89 Grand Master

Beelzebub89

Posted
Posted
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.

Smity42 Grand Master

Smity42

Posted
Posted

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
 Share
Go to topic listing


  • Latest Posts

    • feartherb26
      RB25DE NEO with Haltech ECU

      By feartherb26 · Posted

      If you take the top half of the intake off you can unbolt the flap off the shaft and leave the shaft in there blocking the hole. Then you can remove the little vacuum canister off from under the manifold and get a spare vacuum line to run to the ECU. I can take some photos of it later. Probably best to get the vacuum source to the ECU sorted first though. Mine all worked mint with the base map from the GTT an I've pretty much let the closed loop sort the fueling and took 1 degree out of the whole timing map.
    • Kinkstaah
      RB25DE NEO with Haltech ECU

      By Kinkstaah · Posted

      This IS something you also have to configure in Haltech (or at least I did in the past when going from onboard-to-ECU map sensor and an external MAP sensor in haltech land).
    • Murray_Calavera
      RB25DE NEO with Haltech ECU

      By Murray_Calavera · Posted

      I'm hoping it's something as simple as the ECU is looking for an external MAP sensor, but he is trying to use the onboard MAP sensor.
    • Murray_Calavera
      RB25DE NEO with Haltech ECU

      By Murray_Calavera · Posted

      You won't need to do that if your happy to learn to tune it yourself. You 100% do not need to do that. It is not part of the learning process. It's not like driving on track and 'finding the limit by stepping over the limit'. You should not ever accidently blow up an engine and you should have setup the ECU's engine protection to save you from yourself while you are learning anyway. Plenty of us have tuned their own cars, myself included. We still come here for advice/guidance/new ideas etc.  What have you been doing so far to learn how to tune?
    • GTSBoy
      RB25DE NEO with Haltech ECU

      By GTSBoy · Posted

      Put the ECU's MAP line in your mouth. Blow as hard as you can. You should be able to see about 10 kPa, maybe 15 kPa positive pressure. Suck on it. You should be able to generate a decent vacuum to about the same level also. Note that this is only ~2 psi either way. If the MAP is reading -5 psi all the time, ignition on, engine running or not, driving around or not, then it is severely f**ked. Also, you SHOULD NOT BE DRIVING IT WITHOUT A LOAD REFERENCE. You will break the engine. Badly.
×
×
  • Create New...