Search results for query: *

I spent some time on it this morning and wasn't having any luck. I must have misunderstood your suggestion. Attached is a copy with the spreadsheet with my attempt at the spreadsheet solution. Tylerhttp://www.mediafire.com/file/z0mjmzy3td2/Canada53.xls

Hello,I am working on a spread sheet to quickly provide engineers with seismic Fa and Fv values based on given soil class values (A through E), given Sa(0.2) (a number) and a given Sa(1.0) (a number) based on the Canada building code seismic Fa and Fv charts. The charts are in the attached...

Hello, I am working on a spread sheet to quickly provide engineers with seismic Fa and Fv values based on given soil class values (A through E), given Sa(0.2) (a number) and a given Sa(1.0) (a number) based on the Canada building code seismic Fa and Fv charts. The charts are in the attached...

Yes they do, I confirmed this when I wrote it and reconfirmed when this error started showing up.

Hello, I wrote a macro that imports data from a text file, and uses data imputed in that text file in various other parts of the spreadsheet. Conveniently, the import macro is working fine for everyone in the office except for my boss's computer. When he runs the macro pasted below he gets a...

The syntax fix got it going. Thanks for all your help.

The sheet that I need to hide certain rows on is formated to be printer friendly as building design criteria sheet when printed. Because of this, the page has several blank columns that need to remain to keep the format of the printed page generalized. Here is what I have now: Private Sub...

I need certain rows in a worksheet "Printsheet" to either be hidden or shown based on the contents of specific cells in another worksheet "Input". I was thinking something like this but I am not having much success. If Printsheet.Cells.Range(5, 5) = "A" Then Printsheet.Rows("39:52").Hidden =...

Post moved.

I am working on a macro that will search an imported data file in one tab for a given phrase (Building_length which will always be in column A) then copy the contents of the cell next to it (200 which will always be in column B) and past that value into a given cell on a different tab of the...

I am working on a macro that will search an imported data file in one tab for a given phrase (Building_length which will always be in column A) then copy the contents of the cell next to it (200 which will always be in column B) and past that value into a given cell on a different tab of the...