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!

Search results for query: *

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

    Modify macro to run on active worksheet only

    I use a macro to replace formulas with values, I need to modify it to run on the active worksheet only.Please help, I do not understand visual basic. Here is the code: Sub FormulasToValues() ' ' Replace all formulas with values ' WCount = Worksheets.Count For i = 1 To WCount If...
  2. garvock

    Syntax for 4p ² R/[H²+(2 p R) ²]

    How do I enter the following formula in a cell in Excel. 4p ² R/[H²+(2 p R) ²] Where R=1 and H=10 the answer should be 3.533. I cannot get this answer, but I am not very proficient at math. Any help would be appreciated. P.S. The formula is for calculating the curvature of a helix. I intend to...
  3. garvock

    Excel Macro Format Problem

    I recorded this macro in Excel to convert dates in column A(23/4/04) to text as the file is linked to an Access database and the dates appear as a number, i.e. 38100. The macro works OK but converts the text from 23/4/04 to 4/23/2004(the cell format changes to text OK). How can I do this...
  4. garvock

    Linked excel table has a blank field

    I am trying to link an excel table to access, it works OK but one field loses all it's data. I have tried everything I can think of to rectify this problem but no luck. The cells in the excel table are formatted as text i.e.(addresses) I'm sure the answer is very basic, but I am new to access. Help
  5. garvock

    Parameter Query Numeric Field Overflow

    Hi I am new to using Access. I have an Excel table linked to Access. I have setup several queries and reports with no problems.I am trying to set up a Parameter query using date range " between [start date] and [end date]" but I get a numeric overflow error. I think it may be because...
  6. garvock

    Mouse Not Responding

    Hi Mouse cursor is not responding on booting Win98SE computer. Have tried another mouse that is known to be working. Have reinstalled drivers etc. but no response. Could this be a motherboard problem?
  7. garvock

    Office 2000 crashes on exit

    When I close an Office 2000 application I get the error message "Excel has encountered a problem............ and will close....." The same happens in Word. I have tried reinstalling but no joy. Anyone now the answer to this problem?

Part and Inventory Search

Back
Top