Search results for query: *

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)

ActiveCell.FormulaR1C1 = "=AVERAGE(r[0]c[0]:r[0]c[0])" End Sub Here's the VBA syntax I have so far. I want it to show AVERAGE() so I can select the range for averaging after i click the macro button.

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...

Thank you acron. It worked!

The unhide button is grayed out and cannot be used. This la file is directly linked to another xls file only.

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