Recent content by MSUser

I forgot that the "named range" was embeded in the formula. Thank you.

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!

I have the same problem. Could it be a virus? My norton comes up clean!

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?

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.

I had the same problem. Although on-line virus scans detected nothing, I still believe I had one. First, I unstalled and manually deleted any folders and files related to Symantec and Norton AntiVirus. I then reinstalled a clean copy of IE5.5 I had on a disk. Next, I had to re-update all of MS...

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.

The Wizard does not seem to work for Excel 2000?????

Is there an easy way to search and kill?

Thanks for your help,but how can I get it work just like the SUM button; where the it seeks the cell (closest numbe value(s)) to average.

ActiveCell.Offset(0, 0).Range("A1").Select ActiveCell.FormulaR1C1 = "=AVERAGE(R[-12]C:R[-1]C)" End Sub

This does not seem to work.

I would like to change it to AVERAGE

Select Tools, Options, Edit, select move selection after Enter (chose how)

Select Tools, Options, Edit, select moveselection after Enter (chose how)