array index

  1. T

    VBA automatically update part of range variables based on last column

    My code contains a number of range variables such as the following, which I need to update automatically based on the number of columns (where T is the last column with data, and U repeats the references in colA). Dim fmtRng As Range: Set fmtRng = Range("B3:T15, B20:T32, B37:T49, B54:T66...
  2. C

    Array formula issues

    Hi, I posted a similar question a few days ago and I thought I had solved the problem but something else came up. Basically what happens is my last row keeps changing as I run my array formula macro and it gets bigger and bigger every time the formula runs and as such after a few times using...
  3. R

    smart formulas

    I have a list of football results <tbody> Stoke 0 1 Aston Villa 1 0 West Brom 2 2 Sunderland 2 2 West Ham 0 1 Tottenham 1 0 Arsenal 2 1 Crystal Palace 1 2 Man Utd 1 2 Swansea 2 1 Leicester 2 2 These results continue and the team...
  4. KG Old Wolf

    read letters of a surname sequentially

    This is a perfect use of an array and I am missing something very basic. I am trying to load a surname variable into an array and then index through each element to inspect and assign a value (part of a SOUNDEX routine). I ReDim the array with the length of the surname but the entire surname...
  5. M

    Saving Range in an Array and retrieving any Index from Array

    Hi Guys, I'm really stuck with this code for last 6 hours now. Code is not that completed. Actually I have a range (containing text and numbers mixed) so i'm first saving the range in one variable and then I'm trying to save (or copy) the range to another Array. It works fine to this level. But...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top