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!

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

Search results for query: *

  • Users: getitdaily
  • Content: Threads
  • Order by date
  1. getitdaily

    Excel Macro Error: Procedure too large

    I recorded a macro in Excel and it worked fine on my PC. I emailed the macro to another person and when she ran the macro she got a Compile Error stating 'Procedure too large'. Anyone know what this means?
  2. getitdaily

    Check activecell against a range

    I want to run a command line only if the active cell that is double clicked is in a range. How do I check the active cell against a range?
  3. getitdaily

    Double click in an Excel cell

    Is there a VBA command that lets you control what happens when you double click a cell in Excel?
  4. getitdaily

    Display a calendar after clicking in a cell

    I have a range of cells B1:Bxx that hold a date. The user inputs the date but I'd like to display a calendar for selection after the user clicks in the cell. Any way to do this?
  5. getitdaily

    Find Unmatched Query problem

    I have two tables that have a composite primary key. Dept and Name are individual fields, but combined they create a unique row in my tables. I'm trying to run a Find Unmatched Query on those two tables and was wondering why I can't select both fields when the wizard asks "What piece of...
  6. getitdaily

    Change Sign formula in Excel

    I've looked through all the formulas and I may have overlooked it, but.... Is there a formula in Excel that changes the sign of a number in a cell???
  7. getitdaily

    Blank field in query

    I need to pull field one and field two, with a column in between that doesn't exist anywhere. I would like to add a column in the query and fill it with the value 0.00. How do I do that?
  8. getitdaily

    Change authentication mode

    How do I change the authentication mode that was asked during install once SQL Server has been installed?
  9. getitdaily

    Problem creating a fourth partition

    I'm trying to set up a fourth partition on a new server. I get three created then I don't have the option to create the fourth. Microsoft says it's a known problem. Anyone ever get this problem?
  10. getitdaily

    Reference a sheet that might not exist

    I'm trying to reference one cell to a cell in another sheet that might not exist. Anyway to do that?
  11. getitdaily

    Cell reference to another book

    Here's my scenario (and I hope this makes sense)... I have two workbooks I'll call them book1 and book2. Book1 has a layout sheet and a macro that copies the layout sheet into sheet1 and imports data from a delimited file. The user then renames the sheet with the previous month. Book1 is the...
  12. getitdaily

    Make cell value equal to tab name

    Does anyone know how to make a cell value be the tab value?

Part and Inventory Search

Back
Top