exceeded

Hi All Trying to post a question and I have included two tables, but for some reason I get the error message "The number of tags you tried to add exceeded the maximum number of tags by 1" Is there anything I can do to fix this?

Hello, I have 4 columns A, B, C, and D. Collumn A is a datetime data set and the other 3 are various other number data sets. I would like to enter a value in a cell under column F, G or H and the VLookup would look through columns B, C or D respectively to see if the value was exceeded. If yes...

Hi im trying to develop a formula to identify when a budget has been exceeded. to simplify; B10:G10 contains Jan, Feb, Mar, Apr, May, Jun B11:G11 contains 1, 2, 5, 7, 9, 5 A11 contains the budget, 7 I need the output in H11 to indicate "Mar" representing the month where the budget value...

Hi there I am trying to use vba to check each cells in the column if the date has exceeded 3 days. If so the whole row will be highlighted red. Here is my syntax If Range("a:a").value < Range("a:a").value + 3 then Range("a:a")EntireRow.Interior.ColorIndex = 8 End If However I could not get...

Hi - I'd like to find a formula for column D in this spreadsheet. It uses the adjacent value in column C and then looks in column B to find a 'day' (row) where that value is exceeded. The returned value in column D is the number of days it took to reach the 5% over price value. For example, the...

Hello, Is there a way I can spring a message and exit a routine if Excel receives an out of memory error? I have a routine which does a lot of calculation and importing data via ODBC and on occasion I will get ODBC error System Resources Exceeded- The fix is pretty easy, I just close...