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

    • Per Mark Roberts of Sonictune: Mark Robert Author At this time, no. No ETA either 2016-17 models. You will be able to purchase and install a 2018.5+ TCU though   TCU purchasing and pricing info! As we near the release of TCU tuning, I am going to answer some questions I get asked often.   What do I need for TCU tuning? At this time, you will need a 2018.5+ TCU to be able to tune. If you have a 2016-to early 2018, you will need to replace your TCU with the newer version. One good way to know if your TCU is good is if you have auto upshift in manual mode in 1st gear around 6500 rpms. If your manual 1st gear goes to 7k rpm and will hit the rev limiter unless you shift, you have the older TCU.   Why do I need to buy another ecu license/phone flash if I already have it on my ECU tune? The TCU is its own computer module. It is completely separate from the ECU. Because of this, you will be required to purchase a TCU license and, if your tuner has it, the phone flash license required to tune it via phone/bluetooth.   Do I need TCU tuning? TCU tuning is NOT required. However, the faster your setup, the more it will assist in track and dragy time consistency.   If I’m ECU tuned by (tuner A) can I get my TCU tuned by (Tuner ? Yes, since it’s a different module and a completely separate flash, you can have two different tuners. However, it is highly recommend that you have both tuned by the same tuner. For me, my TCU tuning will directly complement my ECU tuning style and features and running my ECU and another TCU or vice versa MIGHT cause some issues. At this time and for the foreseeable future, I will only be tuning my current ECU tuned customers TCUs.     I have a SYVECS AWD controller. Do I still need it? Yes! The AWD controllers main job is to control your AWD system. However, with TCU tuning, you will no longer need the auto-shift function as that will be done through the TCU. The AWD controller will still be very beneficial for racers looking to maximize traction on the launch.     Shift schedule changes: holding gears longer at lower pedal input as well as max shift rpm changes. Please note, the new ECU race rom coming out will address 90% of the shitty drivability issues these cars have through custom maps from myself and Racebox—as well as others I am sure.   Increase shift speeds: as seen in the videos I’ve been posting, the TCU shifts much faster once tuned.   Increased shift pressures: as also seen in the videos, much firmer full throttle shifts.      
    • Per Mark Roberts of Sonictune:     Mark Robert Author At this time, no. No ETA either 2016-17 models. You will be able to purchase and install a 2018.5+ TCU though   TCU purchasing and pricing info! As we near the release of TCU tuning, I am going to answer some questions I get asked often.   What do I need for TCU tuning? At this time, you will need a 2018.5+ TCU to be able to tune. If you have a 2016-to early 2018, you will need to replace your TCU with the newer version. One good way to know if your TCU is good is if you have auto upshift in manual mode in 1st gear around 6500 rpms. If your manual 1st gear goes to 7k rpm and will hit the rev limiter unless you shift, you have the older TCU.   Why do I need to buy another ecu license/phone flash if I already have it on my ECU tune? The TCU is its own computer module. It is completely separate from the ECU. Because of this, you will be required to purchase a TCU license and, if your tuner has it, the phone flash license required to tune it via phone/bluetooth.   Do I need TCU tuning? TCU tuning is NOT required. However, the faster your setup, the more it will assist in track and dragy time consistency.   If I’m ECU tuned by (tuner A) can I get my TCU tuned by (Tuner ? Yes, since it’s a different module and a completely separate flash, you can have two different tuners. However, it is highly recommend that you have both tuned by the same tuner. For me, my TCU tuning will directly complement my ECU tuning style and features and running my ECU and another TCU or vice versa MIGHT cause some issues. At this time and for the foreseeable future, I will only be tuning my current ECU tuned customers TCUs.     I have a SYVECS AWD controller. Do I still need it? Yes! The AWD controllers main job is to control your AWD system. However, with TCU tuning, you will no longer need the auto-shift function as that will be done through the TCU. The AWD controller will still be very beneficial for racers looking to maximize traction on the launch.     Shift schedule changes: holding gears longer at lower pedal input as well as max shift rpm changes. Please note, the new ECU race rom coming out will address 90% of the shitty drivability issues these cars have through custom maps from myself and Racebox—as well as others I am sure.   Increase shift speeds: as seen in the videos I’ve been posting, the TCU shifts much faster once tuned.   Increased shift pressures: as also seen in the videos, much firmer full throttle shifts.      
    • The fancy pants red shock tower brace is finally incoming from MX5 Mania, getting it shipped from 'Merica has been a long and problematic process, and GWR, the 'Merican supplier will not ship directly to consumers outside of the US, Mania basically had to order a heap of them, the colour choice was silver, or red, and we all know anything red adds 5 killerwasps of dynotorques..... Whilst it does fit over a 2.5, and I've seen a few photos and videos of it being installed and fitting, google also says it might get real close to the FAB9 intake front runner, people in the US says it does fit with the FAB9 intake, except for one person who said it slightly touched.......so there is that.....LOL..... As it seems that I am the first in AU to have this combination of parts there's no local knowledge about fitment, so I'm just a willing guinea pig in this endeavour, I'll cross my fingers and toes and hope for the best In other news, I ordered stuff from China  on the same day I ordered the 23° silicone bend from Victoria, the stuff from China arrived a day ago, the 23° silicone bend is still travelling around Australia thanks to Australia Post, and "may" be here next week
    • Very good news...I contacted Racebox about it last night. My car is a 2016 so remains to be seen if it is compatible, requires a TCU swap, or is impossible.
    • What ECU are you running? This is probably the biggest question. If it's a PowerFC, I'd probably change the ECU and get something newer that will handle the injectors in a nicer way.
×
×
  • Create New...