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

    • The Bogan
      Wheel Sizes & Offsets For Skylines

      By The Bogan · Posted

      The speedo's can be very conservative, when my Mazda NC MX5 speedo is showing 118kph, the GPS, and a calibrated radar.... cop mate.....hits me at around 110kph +/- 1 or 2 kph, and that is on a 215/45 17, stock tyres size is 205/45 17 as well, so weirdly conservative with stock tyre size When my Commodore speedo red 116kph GPS had me at 110kph After doing some offset and clearance measurements to see what can fit the NC on 17x8 +40, without guard rolling or rubbing anything at my current ride height, I've decided that when my tyres are toast, I'm going to fit 225/45 17 and see where that gets me IRT actual speed of my speedo and GPS/radar From the online calculator I should be still be doing around 5kph under an actual 110kph when the speedo is showing 110kph My ADHD requires that when I'm doing 110kph on the speedo, that the actual road speed is actually really close to that, and not alot slower And going from 205 to 225 still keeps the car within the %/mm allowable in the NSW vehicle rules and regulations, which is nice, as long as I'm looking at the latest version that is.....LOL https://www.nsw.gov.au/sites/default/files/2021-02/RMS-13.464-Light-vehicle-modifications-Vehicle-Standards-Information-No-6-November-2013.pdf
    • MBS206
      R34 25GT Engine Light 21

      By MBS206 · Posted

      Take the value it measured as, and pick the closest range available that is above the reading on the screen.   Also, no point just testing the coils. Read what has been said again. You need to test all your wiring, everything.
    • GTSBoy
      R34 Handbrake light saying ON and intermittently flashing

      By GTSBoy · Posted

      Does the scanner do all the CUs in the car, or only the ECU?
    • albyz34gt
      R34 N/a And R34 Turbo (gtt) Transmission.. Uh, Problem.

      By albyz34gt · Posted

      @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
    • RB25inside
      R34 Handbrake light saying ON and intermittently flashing

      By RB25inside · Posted

      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?
×
×
  • Create New...