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 wOOdy-Soft 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: MSUser
  • Content: Threads
  • Order by date
  1. MSUser

    DSUM lfunction imitation for 66 items?

    I have a problem when adding expenses under a field with a date criteria containing more than 66 items. Is there a limitation in the EXCEL function DSUM against more than 66 items. The function does not seem to work beyond row 66!
  2. MSUser

    Excel Macro for Saving File with Name from a Cell

    I would like to create a macro to save an Excel File by referring to a cell within the W/S for the its name and directory. Any Ideas?
  3. MSUser

    NAV 2003 Shortcut and Desktop icons disabled!

    My Shortcut and Desktop are disabled! Howevewr, the MS Internet Explorer (6.0)for NAV icon works! I tried everything!! Virus scans report no infections. Re-installation does not enable these icons. Any ideas? Thanks in advance.
  4. MSUser

    defannity.dll aamd bugbear virus

    I got a message that that the "defannty.dll" file is missing. What does does this mean? Also, my norton virus utility 2003 does not work and I ran bugbear fix for it. I also reinstalled it from the disk and it still does not work.
  5. MSUser

    Excel Severing Links to other worksheets

    Is there an easy way to search and kill?
  6. MSUser

    Does anyone know VBA syntax for Excel SUM button?

    I would like to change it to AVERAGE
  7. MSUser

    How to create maco button for Average like SUM

    I need to create a maco buttom to insert the Average function just like the SUM function(default) button. I know how to create the macro buttom and assign the macro, but cannot get the correct VBA syntax for selecting the range of cells for average function. I want to select the cells like I do...
  8. MSUser

    How can I edit an invisible xla excel file ?

    The file was created in Excel 4.0. It is listed in the VBA Project list, but cannot be open to edit?
  9. MSUser

    Excel 4.0 .xla file Cannot open in Excel 2000 - HELP!

    I have an EXCEL 4.0 xla file with macros that EXCEL 2000 (9.02720) will not open for editing. Any suggestions/help? (
  10. MSUser

    Excel Macros Re write help.

    I would like to inset a column in an excel workbook with a long list of macros. However, when I do the insertion it disables the macros because they still refer to the unshifted cells. Is there an easy way to re write the macros in this situation?
  11. MSUser

    Excel Age Calulation with Calendar Months Count

    How do I calculate a person's age in years with number of calendar months (rounded to the current month). I can get a fractions of year, but not the calendar months. For example Age 43 and 3 months old. versus 43.25.
  12. MSUser

    How do I calculate Age in Years and Calendar Months in EXCEL?

    I need number of calendar months versus fraction of a year or number of days.
  13. MSUser

    JS.Seeker virus found in file C:\removit.hta

    I quarantined the virus and deleted the file because norton anti-virus could not repair it? Do I need this file? If so, where do I get another file?
  14. MSUser

    Convert picture *.art to *.bmp or *.gif

    Is there a way to convert a picture saved as *.art to *.gif or other?

Part and Inventory Search

Back
Top