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

    • GTSBoy
      $5 Clock upgrade for R32 GTR

      By GTSBoy · Posted

      The attached document is fine. I just downloaded & opened it.
    • ToothDR32
      $5 Clock upgrade for R32 GTR

      By ToothDR32 · Posted

      Hello, sorry for being late to join the discussion, but my clock just died on me.   Ive tried to look at Michaels digital clock repair.docx and it doesnt work maybe the file has expired.   Please let me know if you can re upload it or take some youtube videos to show us how to get the clock installed? thanks
    • MissMintyR33
      R33 persistent issues. P/steering and lag/misfire

      By MissMintyR33 · Posted

      I thought that might be the case, thats what I'll start saving for. Thanks for the info 
    • jtha7
      Strange issue RB25DET wont start

      By jtha7 · Posted

      Ps i found the below forum and it seems to be the same scenario Im dealing with. Going to check my ECU coolant temp wire tomorrow    From NICOclub forum: s1 RB25det flooding at start up Thu Apr 11, 2013 7:23 am I am completely lost on this. Car ran perfectly fine when I parked it at the end of the year. I took the engine out and painted the engine bay, and put a fuel cell with an inline walbro 255 instead of the in tank unit I had last year. After reinstalling everything, the engine floods when the fuel pump primes. if i pull the fuel pump fuse it'll start, and as soon as I put the fuse back in it starts running ridiculously rich. I checked the tps voltage, and its fine. Cleaned the maf as it had some dust from sitting on a shelf all winter, fuel pressure is correct while running, but wont fire until there is less than 5psi in the lines. The fuel lines are run correctly. I have found a few threads with the same problem but no actual explanation of what fixed it, the threads just ended. Any help would be appreciated. Rb25det s1 walbro255 fuel pump nismo fpr holset hx35 turbo fmic 3" exhaust freddy intake manifold q45tb q45 maf   Re: s1 RB25det flooding at start up Fri Apr 12, 2013 5:07 am No, I didn't. I found the problem though. There was a break in one of the ecu coolant temp sensor wires. Once it was repaired it fired right up with no problems. I would have never thought a non working coolant temp sensor would have caused such an issue.
    • jtha7
      Strange issue RB25DET wont start

      By jtha7 · Posted

      Hi sorry late reply I didnt get a chance to take any pics (my mechanics on the other side of the city) but the plugs were fouled from being too rich. I noticed the MAF wasn't genuine, so I replaced it with a genuine green label unit. I also swapped in a different ignitor, but the issue remains. I've narrowed it down a bit now: - If I unplug and reconnect the fuel lines and install fresh spark plugs, the car starts right up and runs perfectly. Took it around the block with no issues - As soon as I shut it off and try to restart, it won't start again - Fuel pressure while cranking is steady around 40 psi, injectors have good spray, return line is clear, and the FPR vacuum is working. It just seems like it's getting flooded after the first start I unplugged coolant sensors to see if its related to ECU flooding but that didnt make a difference. Im thinking its related to this because this issue only started happening after fixing coolant leaks and replacing the bottom part of the stock manifolds coolant pipe. My mechanic took off the inlet to get to get to do these repairs. My mechanics actually just an old mate who's retired now so ill be taking it to a different mechanic who i know has exp with RBs to see if they find anything. If you have any ideas please send em lll give it a try. Ive tried other things like swapping the injectors, fuel rail, different fuel pressure regs, different ignitor, spark plugs, comp test and MAF but the same issue persists.
×
×
  • Create New...