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

    • I guess one thing that might be wrong is the manifold pressure.  It is a constant -5.9 and never moves even under 100% throttle and load.  I would expect it to atleast go to 0 correct?  It's doing this with the OEM MAP as well as the ECU vacuum sensor. When trying to tune the base map under load the crosshairs only climb vertically with RPM, but always in the -5.9 column.
    • AHHHH gotchaa, I'll do that once I am home again. I tried doing the harness with the multimeter but it seems the car needed a jump, there was no power when it was in the "ON" position. Not sure if I should use car battery jump starter or if its because the stuff that has been disconnect the car just does send power.
    • As far as I can tell I have everything properly set in the Haltech software for engine size, injector data, all sensors seem to be reporting proper numbers.  If I change any injector details it doesnt run right.    Changing the base map is having the biggest change in response, im not sure how people are saying it doesnt really matter.  I'm guessing under normal conditions the ECU is able to self adjust and keep everything smooth.   Right now my best performance is happening by lowering the base map just enough to where the ECU us doing short term cut of about 45% to reach the target Lambda of 14.7.  That way when I start putting load on it still has high enough fuel map to not be so lean.  After 2500 rpm I raised the base map to what would be really rich at no load, but still helps with the lean spots on load.  I figure I don't have much reason to be above 2500rpm with no load.  When watching other videos it seems their target is reached much faster than mine.  Mine takes forever to adjust and reach the target. My next few days will be spent making sure timing is good, it was running fine before doing the ECU and DBW swap, but want to verify.  I'll also probably swap in the new injectors I bought as well as a walbro 255 pump.  
    • It would be different if the sealant hadn't started to peel up with gaps in the glue about ~6cm and bigger in some areas. I would much prefer not having to do the work take them off the car . However, the filler the owner put in the roof rack mount cavities has shrunk and begun to crack on the rail delete panels. I cant trust that to hold off moisture ingress especially where I live. Not only that but I have faded paint on as well as on either side of these panels, so they would need to come off to give the roofline a proper respray. My goal is to get in there and put a healthy amount of epoxy instead of panel filler/bog and potentially skin with carbon fiber. I have 2 spare rolls from an old motorcycle fairing project from a few years back and I think it'd be a nice touch on a black stag.  I've seen some threads where people replace their roof rack delete with a welded in sheet metal part. But has anyone re-worked the roof rails themselves? It seems like there is a lot of volume there to add in some threads and maybe a keyway for a quick(er) release roof rack system. Not afraid to mill something out if I have to. It would be cool to have a cross bar only setup. That way I can keep the sleek roofline that would accept a couple bolts to gain back that extra utility  3D print some snazzy covers to hide the threaded section to be thorough and keep things covered when not using the rack. 
    • Probably not. A workshop grade scantool is my go to for proper Consult interrogation. Any workshop grade tool should do it. Just go to a workshop.
×
×
  • Create New...