variable ranges

  1. J

    VBA: 2 specific problems: 1 - set table row as range and 2 - refine existing code

    Hi all Below is a bit of code. I prompt user to select a cell (although so far its possible to select more than one but I'll fix that) as starting point from which a table will be inserted. Then I prompt for user input to specify the range in a pivot table frequency array formulas calculations...
  2. L

    Populate a combobox from a variable sheet and variable range

    Hi everyone, Ive been struggling with this for 2 days now I could really use some help. I have the following problem: Ive got a sheet1 named "initial" in wich ive got a bunch of buttons that open up different userforms, before the user is able to press the buttons he must choose between 3...
    • LGRL20
    • Thread
    • combobox combobox populate populate combobox variable ranges
    • Replies: 4
    • Forum: Excel Questions
  3. P

    Copying down a formula in a variable length range?

    I have a spreadsheet that builds from existing data. The number of rows may vary depending on the data required, but all rows are filled and consecutive. I need to copy down a formula in a column from the top cell, but I can't get the logic to work in getting the Range().Select or...

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