Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

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

Recent content by Tim401

  1. Tim401

    Highlighting data (as opposed to formulas)

    Alternaticelly heres a quick and dirty macro that selects all cells with formulae and formats them White-on-black Sub HighlightFormulae() Selection.SpecialCells(xlCellTypeFormulas, 23).Select With Selection.Font .ColorIndex = 2 End With With Selection.Interior...
  2. Tim401

    Macro to insert DWG

    The only way I think this can be done is to first use a script in AutoCAD to export the image as a metafile or .jpg then in excel use a VBA cell event to import the image. Sorry not sraight forward an will require a small amount of both VBA programming and AutoCAD scripting/AutoLISP
  3. Tim401

    Highlighting data (as opposed to formulas)

    how about the Shortcut key that toggles between view normal and view formulas Ctrl - ` (the ` is the unused key to the left of the 1)
  4. Tim401

    Efficient Tables

    I have a speadsheet that looks a table and selects the appropriate value - bit like a bus timetable. How can I email you a copy through the forum?
See more

Part and Inventory Search

Back
Top Bottom