Recent content by ajh1

Skip, for some reason I never had an issue with the debug button that you were able to remove and reinput and clear the problem. My issues were with either the cmbEnvelope or cmbRoofShape combo boxes. Ultimately I chose to reconfigure those into in-cell drop down lists and eliminate the combo...

Thanks for your efforts, Skip. Personally, I'm still weekday worker (another year or so) so I try to avoid thinking on issues such as this over the weekend. There are about 10 paths that end up calling FillActiveCCWindZones. Most of my hits have been as part of one of the combo boxes up near...

Here it is. See attachment.http://files.engineering.com/getfile.aspx?folder=23876b59-2eaa-47d1-b5a4-ae102dc8ba1d&file=2018_IBC.xlsm

My sentiments exactly, but why is it being called? Happens when I try to close the workbook. I am on the "CC Wind" worksheet at the time. Call stack: VBAProject.Sheet1.cmbEnvelope_Change VBAProject.Snow_WindRoutines.FillActiveCCWindZones VBAProject.Snow_WindRoutines.InitializeCCZoneArea...

The error now points to the With Worksheets("CC Wind") line. Any idea why this logic is even trying to execute when closing the workbook? Al..

I'm baffled by what is happening with this error. In reading a lot of posts on-line the normal issue is a failure to fully define a Range. In my case I believe I have defined everything and the attached logic works perfectly during the time I am within the spreadsheet. The problem develops...

If you expand out your first example you get the following: IF(OR(G4="JZ110RTK0001",G4="JZ190RTK0001") then IF(COUNTBLANK(J4)then IF(OR(G4="JZ135RTK0001") then IF(COUNTBLANK(I4)then "Failed Check 1", else "Passed Check 1" endif) endif) endif) endif) (Note in this case you...

Why number them at all, at least from a display perspective? If the numbers only appear to you as the creator and don't show on the screen when you display them who really cares what number sequence exists.

I got upgraded to a new computer at work last week and among the things that shifted was they updated my Office suite from 2010 to 2013. I have several Excel programs that in use by our production engineers and typically they use a combination of ActiveX controls, primarily combo boxes and...

I had a contract programmer once on a structural engineering program. I gave him a spec for a particular variable that was sort of the typical form, C1 = 0.5 <= some equation <= 1.0. He came over to me and indicated he couldn't program that. When I asked why not, he said it had too many...

I was visualizing a red panda with a newspaper printed on it directly.

I appreciate your story Skip. I had a mentor some 20 years ago who had an office with a low bookcase under a strip of windows. On the top of the bookcase he had stacks of papers about 12" high over the entire top of the bookcase. I came into his office one day looking for some specific piece...

Saw one over the holidays. H8 COLD Since it was a Nebraska plate my initial reaction was, "Boy, do you live in the wrong state!

Saw one the other day: PONYRDE Needless to say it was on the back of a Mustang.

Not sure about Excel, but in Word in many cases hyperlinks attach to the local folder. If you move the file without moving the files that it is linked to, you get a hyperlink that can't find the file it is looking for. If you do the full server\path\file nomenclature it should find it...