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!
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.
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.