I have added in the following references into Excel via the big button in the upper left and the 'Excel Options' screens:Īnalysis Toolpak and Analysis Toolpak-VBA. If ColumnCounter > PrintColumnMarker Then If Trim(Worksheets('Measurements').Cells(RowCounter, ColumnCounter).Value) '' Then TRIM is highlighted in the following code: (See below for the whole sub) The button had worked in Excel 2003- but now (without any changes) throws an error 'Compile Error: Cant find project or library.'
They put in a button that allows portions of the worksheet to print.
I am preparing to make a few alterations to a spreadsheet that another person built.
