Search results for query: *

Thanks, Skip! That did the trick.

I suppose that's fair enough... although it doesn't do much yet, and it does do what it's supposed to if I give it contiguous cells: Public Function compareGrades(cellSet As Range) As Double Dim grades(13) As String Dim scores(13) As Double Dim gpa As Double 'set of letter grades grades(1) =...

Not quite, Skip. That does work for the native AVERAGE function, but I need to get this to work for a user defined function. The function myAverage does something rather different (in this case, taking letter grades and rendering out a grade point average). So there's got to be something I'm...

This is one of those how-do-you-do-it type questions, where I hope the answer is (relatively) simple. I'm working on a user-defined function that takes averages between cells. The cells need to be from multiple worksheets. So to call the function within the workbook, I'd use...

Having a hard time tracking an answer to this down on Google, because I'm not interested in making dialog boxes... I want to be able to detect and click buttons on dialog boxes. Background on this: I have a set of subs that fill out and submit an online form in a browser window. The form...

PH - That did the trick... thanks!

Most of what I can find online with this seems to presuppose that I'm using IE6, an older version of Excel, or in most cases both. I need Excel to be able to look for and address multiple windows, or tabs, in Internet Explorer. The basic syntax - for older builds of these two apps, I think, is...

Yep, that was it. Thanks, I thought it was stupid and obvious but apparently over my head for a Friday. Closing...

I've been able to get navbars with submenus to work numerous times with this code: function flipIndex(whych, whereExx, whereWhyy) { flipOut('serviceTwo'); flipOut('texnosTwo'); flipOut('webApsTwo'); document.getElementById(whych).style.zIndex=1...