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

    • Shouldn't need a "base map" for anything other than guidance to ignition tuning. You just need the engine capacity right, the injector size right, and something, almost anything, for a VE map. On an NA engine, fuelling is almost completely a function of load signal & rpm. It should run and drive with a completely flat fuel map. It will be too lean under load, but that's easily fixed. We used to tune all ECUs without any base map. There were no such things (until someone had tuned a near stock engine on one, and then they had a "base map".
    • What did you actually buy/how much did it cost? When I got mine in like.. 2017...? 2019? the aim was to run Torque for gauges via ODB2 and things like Track Addict/Laptimers/Dashcam/Reversecam/Spotify etc. Mine never broke, but I wonder if you've got the same needs (it sounds like it). Cause I liked the idea of being able to do anything with it. That said, yours also cost 3x the cost of what I spent so... food for thought.  
    • For me there is a massive difference in manufacturer or big brand crippled android (Sony, Kenwood etc) vs the sort of thing I've installed here, which is basically just a tablet in DIN form factor with open Android, and the other model of course is mirroring - Android Auto/Carplay. I hate the locked down manufacturer and AA options where they decide what apps I'm allowed to install, including the Launcher but also importantly things like Ecutek (for this car) or Real Dash (Stagea) are not supported. Plus those crippled versions tend to be slower due to both overheads and lower spec hardware. On the other hand, when this breaks I'll likely be in trouble for support....but how is that different to owning an Infiniti anyway
    • Yeah, Duncan is helping sell me back to Android devices. I've hated the whole Android head units due to their speed issues. Even in my old Hyundai Kona (2022 model), it behind the scenes was Android, and slow and shitty to start up. Once running wasn't bad, but still a good 15 to 30 seconds.
    • My roof rails are off atm on the E39 until the rust is fixed. I did find another little bit of surface rust under the rails when I took them off. As @soviet_merlin said I'd just leave them alone unless you're planning on ensuring they're properly sealed. I was on the fence about leaving them off as the delete is still a thing in BMW E39's but I feel like the car is missing something (er, it is, der) with them off and I'm looking forward to putting them back on.
×
×
  • Create New...