range formula

Hi ! I have built a user form to enter data of my field of Radish in point of Sales Record. The form is working good and entering the values correctly by these codes. But I have put some charts and additional data in my excel sheet upper rows. User form enters the value at the 2nd top row and...

I am having a terrible time understanding Excel's calculation modes and when exactly the message *CALCULATE* appears on the bottom left of the status bar. Let me boil down this down to one use-case. Say you have your spreadsheet set to Manual mode. Further assume you have a subroutine that...

Hi everyone, Thanks for reading my question. Here is some background: I have some code that uses a formula to write a formula then its result into a selected range of cells that are in a table. It works fine for a formula such as: rng.Formula = "=COUNTIF([Material Number],[@[Material...

I have a list of name in column A, a list of numbers in column B to start with. In week 1, I will be entering numbers into column C and I need a formulas to tell me the name (column A) of the person who increased their numbers the most (B2 compared to C2 for example). Thanks!

I need to keep a running tab of times that fall according to certain time parameters. There are 3 columns that have <=60, 61-120, and >120. I have formulas successfully plugged into column A and column C. The significant hitch is that I am forced to use Office 2003 at work. I know countifs...