• WSDave4237

    WSDave4237

    @wsdave4237

    Viewing 2 replies - 1 through 2 (of 2 total)
    Author
    Replies
    • in reply to: Replacing formula values #1243672

      Your statement has a quotation mark before the comma and word Replacement. Change this:

      Selection.Replace What:=”-F” & ACPos & “, Replacement:=”-(F” & ACPos & “-L” & ACPos & “)” , LookAt:=xlPart, _
      SearchOrder:=xlByRows, MatchCase:=False

      to this:

      Selection.Replace What:=”-F” & ACPos & , Replacement:=”-(F” & ACPos & “-L” & ACPos & “)” , LookAt:=xlPart, _
      SearchOrder:=xlByRows, MatchCase:=False

    • in reply to: Whats wrong in the picture? #1187955

      In the roof construction picture, the top of the windows on the second story are at the bottom of the roof line. People on that floor would hit their heads on the ceiling when looking out the windows.

      Also, roof shingles and tiles are not packed in boxes with diagonally cut sides–shingles use no boxes and tiles would fall out the short side of the box.

      * * * * *
      In the bicycle picture, the box of flowers is too long to fit in the basket.

      –Dave

    Viewing 2 replies - 1 through 2 (of 2 total)