I recently was befuddled with some VBA code and had to sort things out.
The statement to change the application's calculation mode is:
Application.Calculation = [something]
I've always used (well, for 20 years or more?) the "somethings" as:
= xlCalculationAutomatic
=...
John Hancock Center is one of the tallest buildings in Chicago (okay, I guess its name was officially changed earlier this year).
One of the express elevators to the restaurants and observation level at the top of the building experienced broken cable(s) this week. A number of news articles...
On occasion I open a workbook and where I had previously pasted an image of something, instead there is a 'box' placeholder with a 'red X' in the top left, and the caption "The image part with relationship ID rID1 [the digit may vary] was not found in the file".
This is worrisome as the...
So I am documenting my investigation of "Health Savings Accounts" in the USA, commonly referred to as "HSA"
Excel keeps regularly and willfully changing my typing HSA to HAS. I don't understand why.
The AutoCorrect settings are set to "Ignore words in UPPERCASE". Plus I capitulated and added...
That's the country of Colombia.
A major bridge, 440 metres span, collapsed during construction. Seems to be a cable-stayed bridge with concrete towers and deck. Seems like one tower and span collapsed during construction, killing at least 10 workers...
I'm using the Excel feature to access external data from the web. The data source is a Google Sheet that has been published.
I have a simple routine to refresh the data ("ThisWorkbook.RefreshAll"). But subsequent commands seem to execute before the external data has been fully refreshed...
I used the "Search" field in the Excel File/Open dialog to search for workbooks containing the word "curvature". I got some hits and opened them all. I could find the presence of "curvature" in all files except one. I use the workbook search tool (making certain that all sheets are visible) and...
[Excel 2016] In customizing the Quick Access Toolbar (choosing from 'All Commands') there is the tool to "Open" files, which is the same as selecting File / Open. Either method uses the "Backstage". The "tooltip" when hovering over this selection while customizing the QAT even indicates...
I have been dragged kicking and screaming into using Excel 2016. "Upgrading" from my old Excel 2007 (which was itself another kicking and screaming story).
Okay, it seems to run all of my VBA and standard workbooks without too many hitches [okay, in hindsight that was TIP #3]. But I just don't...
Is it possible to "hide" the text on a VBA module in Excel?
Reason I ask is I was given a very complex (publicly distributed) workbook about "Topic A". There are a number of modules, mostly of very simple code and about half or more of which have no text at all. I tried Ctrl + End to go to the...
I happily use Excel 2007 on my office computer (3-4 year old Dell with Windows 7). And on my 10 year old Sony Vaio running Windows Vista. And I happily use a lot of VBA in the process.
I just purchased a new personal laptop with Windows 10 and debating about getting Excel 2016. The reviews at...
I have been using Excel since Excel 3.0 with the old xlm macro language. Not that I consider myself an expert on Excel by any means, just a good journeyman.
For entertainment, here are a few of the things that have driven me batty with Excel over time. No telling how many hours were expended...
Every so often I stumble across Excel issues that I investigated years before (this occurs in my work life too) and have forgotten.
So I just realized that Excel 2007 offers the xlsm and the xlsb formats. My copy of Walkenbach's book for 2007 barely even mentions the xlsb format. But he does...
Can someone identify this "mystery" formula purportedly from AISC for "unity" check? I was provided with this formula in some calculations; due to the context I assume they are referring to the combined load checks for beam-column. I can't identify this in the 9th or 13th Editions of the AISC...
Using VBA (and Excel 2007), I have a problem with a line where I want to change the cell referenced by a name.
All I am trying to do is assign an existing name to a new cell. In simplest form:
Sub Red()
Dim WB As Workbook
Dim WS As Worksheet
Set WB = ActiveWorkbook
Set WS =...
Is the IBC (or portions thereof, say, for wind and seismic?) adopted in any countries outside the US?
My partial answer is "yes", Saudi Arabia and Abu Dhabi, as per SK Ghosh: http://skghoshassociates.com/SKGAblog/viewpost.php?id=37
But are there any other countries?
I am interested in analysis of anchor bolt tensile loads for vertical pressure vessels. ASCE has a publication "Anchorage Design for Petrochemical Facilities". The initial edition was published in 1997 (combined as "Wind Loads and Anchor Bolt Design for Petrochemical Facilities", two books in...
I have an Excel workbook with 303 VBA routines in it. There is a "phantom" routine that I just found uses the keystroke shortcut: Ctrl + r. This file has been around for 20+ years so who knows when/where/why I set that up. I sure don't.
The phantom routine is capable of running as soon as the...
Any suggestions for a basic steel design text utilizing LRFD?
I just checked Schaum's Outlines site and they still have the "Structural Steel Design (LRFD)" by Rokach that I've had since 1991. They are still re-publishing the same Edition so I'd be getting nothing new here.
Is this Schaum's...
I have worked with D-100 in the long distant past but do not have access to the current Edition. Are the rules for allowable longitudinal compressive stress (or critical buckling) given in AWWA D-100 Section 13.4.3.4 based on Clarence Miller's method that is the basis for the new ASME Section...
