Hi All.
According to a third party report I have, an 8x12 beam notched both sides @ 24" o.c. for 4x8 timber floor joists has the following remaining
section properties. (It's basically an inverted "T" at each joist location with the space between the joists acting as solid blocking)
Area =...
Hi All.
This seems like it should be easy and I know I've done something similar in the past.
Sub ScrollToName()
Dim RN As Integer
RN = Range("P5").Value
ActiveWindow.ScrollRow = RN
[highlight #FCE94F]Range("E + RN").Select[/highlight]
End Sub
It scrolls to the top perfectly but I can't seem...
Mike. I came up with this last night.(I was half asleep so go easy on me) It's probably as complicated as your detail (if not more) but may have some possibilities. I am not a mason and can't tell you what size steel to fabricate it from but as a first attempt I think may have some merit.
After...
Interesting question. I believe the US code says that tread widths within any flight of stairs can vary no more than 3/8".
Key words being "within any flight of stairs" I haven't found anything regarding successive flights of stairs (separated by landings).
Not sure if this is the case here...
I'm trying to foolproof a spreadsheet. I would like the user to input feet and inches in a certain format. I need a formula to use in conditional formatting that highlights a cell if the input is not correct.
It must be input as in these examples, 12'-6" or 12'-6 1/2"
The correct procedure...
Just thought of this. Here's a thought based on my experience with this type of lumber. Most of the time we had full packs of pt lumber delivered to the job site based on the size of decks and such that we were building. If the packs had been exposed while stored at the lumberyard (uncovered)...
The 2x is appears to be a piece of treated southern pine. The green hue comes from the treating process. It's almost as hard as the concrete it sit's on! If you've ever tried to drive a nail thru it after its aged (even a short while)you know that you have a better chance of hitting the lottery...
I just printed a dimension of 6" to pdf from model view to a pdf set at 1:1. Opened the pdf in Adobe Reader and printed it set to "Actual Size". Granted, my eyes aren't what they used to be but my Stanley Power Lock showed it spot on. Printed with an old HP DeskJet 5650.
If you are printing...
The roof is a 12/12 pitch. Vertical load should be quite small. At 25' wide it is 12 and a half feet tall +/-. Basically it's a giant sail! As far as vertical loading I agree with Archie:
With that said I've attached a drawing that i think is fairly close to the existing structure.(please...
Yakov. It looks like your suggestions made the difference. It seems to be working fine now.
I'm sure I will have to make changes to it as the spreadsheet progresses but it's a good start.
It may not be the prettiest code but with the limited time I have to work on it it'll suffice for now...
Sorry Guys. Here is the code.
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Dim isect As Range
Set isect = Intersect(Target, Range("D:D"))
Dim a1 As Range
Dim targetoffset As String
Dim notes As String
Set a1 = Range("a1:a1")...
Hi all. I have tried for quite a while to figure out what is wrong with this code.
I've attached an image of the code and the error. It has to do with the vlookup portion of the code.
I want a message box that shows the notes determined by the vlookup.
I think it has something to do with the...
Thanks for the reply IRstuff, and you are right. That would be perfect if the description of my problem was accurate.
I should have done this before. I've included a picture that I hope is a better representation of my dilemma.
Thanks again, Doug
Hi All,
Wondering if you could give me a hand with this. I need a formula that will:
Sumif column D if the contents of column C are in column B and have an "x" next to them in column A.
I've picked this apart but can't find the right combination of functions to make it happen!
A B C...
