What a day

[Isaac]

I recently wrote a function to determine whether 2 Excel workbooks were the same - Sheet count, Sheet names, Header values of all sheets. (True/false).

Over the past 24 hours, I've probably spent 3-4 hours troubleshooting why it was returning "False" when I KNEW the files were the same - I created one as a copy!

Having gotten to where I usually write code correctly the first time, I was so perplexed. I sat in debug mode, staring at a Set statement failing to Set -

For Each wsOld in wbOld.Worksheets
Set wsNew = wbNew.Worksheets(wsOld.Name)
...
Next wsOld
etc.

My most recent hunch was there was something about wsOld.Name that wasn't appropriate for a Worksheets() index reference - even though MS clearly states Worksheet.Name returns a String Value, so it must be OK.

Literally 3 hours........Until I realized something extraordinary. Worksheet is not spelled Worksheeet

Who knew !?

 

[conception_native_0123]

LOL. welcome to the coding world! ha ha ha. at least I'm not the only one!

 

[NauticalGent]

Let those amoung us who have not misspelled, cast the first stone.

Glad to see it isn't only me...

 

[conception_native_0123]

cast the first stone

per @The_Doc_Man , there is no stoning anyone who is part of this board. Stephen thousands of years ago would be an exception.

 

[AccessBlaster]

I thought you were going say there was a hidden space or something like that.

 

[The_Doc_Man]

Well, Holy Sheeet, Batman!

 

[Galaxiom]

Reading exactly what is written rather than what is expected is a skill picked up after many years of coding.
I also do a lot of proof reading where I work. Noticing valid but inappropriate words that are not evident in spell checkers needs that kind of attention. Noticing inconsistent punctuation is a speciality as it is so important in coding.

 

[Isaac]

Reading exactly what is written rather than what is expected is a skill picked up after many years of coding.
I also do a lot of proof reading where I work. Noticing valid but inappropriate words that are not evident in spell checkers needs that kind of attention. Noticing inconsistent punctuation is a speciality as it is so important in coding.

Agreed. I was surprised at how much time I spent with my eyes looking directly at the three e's in worksheet and not seeing it. Crazy