variable count

  1. M

    Macro to add Borders

    Hello, I'm looking for a Macro to add Thick Outside Border to set width of columns, but will only extend down to the rows that are populated with info. In terms of my spreadsheet, The top of the Thick Outside Border will cover A5 to D5 and extend down for the cells that are populated. My gut...
    • MJA001
    • Thread
    • extend macro outside border populated variable count
    • Replies: 6
    • Forum: Excel Questions
  2. J

    Count the rows of Variable Tables Multiple times - Separated by a space

    Hello, I have a spreadsheet with multiple variable tables. I would like to get a count of rows for each table. The tables are separated by a blank row. Is there a way I can do this using VBA? The pattern could look something like this. 4 rows of data blank row 3 rows of data blank row 7 rows...
    • jrake40
    • Thread
    • count rows row count variable count variable data
    • Replies: 0
    • Forum: Excel Questions
  3. T

    Increment in Loop Help

    What would be a good way to increment each of my ranges for example I need x to copy Range B11:to G20 and paste it to C10 for the second loop. Each Variable has different increments. Any Help is appreciated cause I'm horrible with Visual Basic. Sub Macro5() ' ' Macro5 Macro ' Dim i As...
    • taugdog21
    • Thread
    • loop a macro loop and copy variable array variable count
    • Replies: 1
    • Forum: Excel Questions
  4. M

    Handling Variable Number of Rows in Lookup and Index

    Hi... I think this will require VBA.. I need a function that will look up the entries of Sheet1-Column-A in Sheet2-Column-A. If an entry in Sheet1-Column-A exists in Sheet2-Column-A, then I need to copy Sheet2-Column-D and Sheet2-Column-E into Sheet1-Column-D and Sheet1-Column-E. I need to do...
  5. G

    Multiple & Variable Dynamic Count

    Ok, I came up with the need of modifing something already solved here is the case. In Column A you can see the serial, Column C states the ammount of times that serial is in the column and only displays this number the first time it appears in the column; formula [...
  6. G

    Count Unique Values Based on Another Column

    Ok, I came up with the need of modifing something already solved here is the case. In Column A you can see the serial, Column C states the ammount of times that serial is in the column and only displays this number the first time it appears in the column; formula [...

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