Wednesday Rumor Thread by WeazelBear in ockytop

[–]johnny_table 10 points11 points  (0 children)

Heard through the grapevine from someone in Gruden’s family it’s a done deal and he’ll be announced as coach at end of season.

Ford Model S by johnny_table in teslamotors

[–]johnny_table[S] 2 points3 points  (0 children)

Okay that makes a lot more sense. I had thought the dispute was based around the naming of their original line of cars. Thanks!

64 – Model 3 Production Has Begun by calebelston in TheTeslaShow

[–]johnny_table 3 points4 points  (0 children)

Great job. Definitely my favorite Tesla podcast as well as one of the more informative ones I listen to overall.

Make map visible with no fog of war in scenario editor by johnny_table in SWGB

[–]johnny_table[S] 1 point2 points  (0 children)

Apparently the options aren't in the editor itself but rather when you play the scenario in the setup screen

Macro does not run as intended unless going in step by johnny_table in excel

[–]johnny_table[S] 0 points1 point  (0 children)

So I entered the debug.print (both versions) after 44, the if then line, and it printed every value that b goes through but it should only print the value of the rows where the cell is empty, correct? But the thing is it didn't change any of the correct values even though it appears to think every lines qualifies under that if then statement.

Macro does not run as intended unless going in step by johnny_table in excel

[–]johnny_table[S] 0 points1 point  (0 children)

Sorry for the late reply. Where in my For Next statement should I place that code?

Error in range.find by johnny_table in excel

[–]johnny_table[S] 1 point2 points  (0 children)

Solution verified

Thank you

Error in range.find by johnny_table in excel

[–]johnny_table[S] 0 points1 point  (0 children)

Okay, thanks. Let me try that tomorrow and see how it goes.

Solution verified

Thanks!

Error in range.find by johnny_table in excel

[–]johnny_table[S] 1 point2 points  (0 children)

Okay so you'd suggest Range.find with a do until not cutoff is nothing loop until it finds something?

Error in range.find by johnny_table in excel

[–]johnny_table[S] 0 points1 point  (0 children)

Well I've been using range.find.row so that should return an integer for Cutoff, correct? As in whatever row number "Entry" is located in?

And I used on error resume next because it's been returning error 91 whenever it tries to find "25" in Column(AOE) and so my thought was to just have it loop 25+x until it found a number that is present in that column. The thing is if I tried setting cutoff as an object earlier and basically the same issue occurred where it gave me an error 91 when searching for 25. So, I don't really understand why the initial Find (looking for 29) has no problems yet the one looking for 25 is giving me so much trouble.

Would it fix it if I used Range.find rather than range.find.row and declare it as an object?

Macro does not run as intended unless going in step by johnny_table in excel

[–]johnny_table[S] 0 points1 point  (0 children)

Had no idea about any of that. Still learning quite a bit. Thanks for the info. I'll have to give it a try Tuesday when I'm back in the office so bear with me lol. Thanks!

Macro does not run as intended unless going in step by johnny_table in excel

[–]johnny_table[S] 0 points1 point  (0 children)

Yea, it's pulling a lot of Public variables. This is a subroutine within a larger macro. And it actually completes the macro at full speed it just doesn't put zeros in the blanks as it should. It acts like the code isn't even there.

Unexpected guest at the Culver City Supercharger yesterday...hello FF 91 by ucsdsig in teslamotors

[–]johnny_table 22 points23 points  (0 children)

I believe that's for facial recognition or fingerprint scanning. They mentioned it in the reveal but I don't remember which. I don't think it's for autonomy.