Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by foilprint0

  1. foilprint0

    Get rid of #N/A

    Hi I have a row of cells with the following type of formula =HLOOKUP(F29,HANDI!$C$9:$AF$26,18,TRUE) when the cells that this refers to has values in it is fine but when they are empty I get #N/A Is there a way of not having the #
  2. foilprint0

    opening a workbook on a set worksheet

    Hi Wondered if it is possible to set the first workshhet in a workbook as the opening page every time the workbook is opened, rather than the last worksheet viewed.
  3. foilprint0

    Excel 2000 hide formulas

    Thanks for that I had just worked that out. Cheers
  4. foilprint0

    Excel 2000 hide formulas

    I have created a workbook that I have hidden rows and locked cells what I wanted to know is:- Is there a way of hiding the formula in a cell? Cheers for any help
See more

Part and Inventory Search

Back
Top