S
Simple_Simon
Dear Sir/Madam
I have created several worksheets (all the same) for
spreadsheets with slightly different titles. There are 20
cells on each worksheet which have a drop down list,
these lists are adjacent to cells with a VLOOKUP formula
which then retrieves the info from a database within the
workbook.
The problem is that i have created a macro which will
Auto Fit the cells to the text once the cells have found
the required data (from VLOOKUP), this works fine on the
first worksheet but will not work on the rest. The
AutoFit will not work even when i do it manualy
Format>Row>AutoFit.
Can Anyone put me out of my misery!!!!
Simon Scott
I have created several worksheets (all the same) for
spreadsheets with slightly different titles. There are 20
cells on each worksheet which have a drop down list,
these lists are adjacent to cells with a VLOOKUP formula
which then retrieves the info from a database within the
workbook.
The problem is that i have created a macro which will
Auto Fit the cells to the text once the cells have found
the required data (from VLOOKUP), this works fine on the
first worksheet but will not work on the rest. The
AutoFit will not work even when i do it manualy
Format>Row>AutoFit.
Can Anyone put me out of my misery!!!!
Simon Scott