dynamic selection

  1. R

    Selecting specific range in VBA

    I'm trying to select a range of cells based on the condition in a preceeding column. For example if [L12] = 1 then select cells [N12:Q12]. This initial part I have no problem with but looping through a range of L cells raises I'm having trouble with. This is my current code Dim k as integer...
  2. A

    Error in Copying Dynamic Ranges with Static Number of Rows

    Hi all, I am using VBA to copy the first 10 rows (including Headers) of data in every sheet of a workbook to a "master", or summary, sheet. The number of columns changes from sheet to sheet, and the total number of sheets will change as well (over time). After I copy each selection, I want to...
  3. L

    Cross reference in dropping list

    Hello Everyone! First of all, let me say that I am not the kind of person who doesn't look for a solution before asking for help. If the solution to my problem is already out there then it's well hidden ! I have a document with several spreadsheets. The first one is my working document...
  4. P

    Issue when trying to select a line of a ListBox control via VBA code

    Hello, My problem is I cannot select dynamically a line of a ListBox control with VBA code. To be precise, I have a form called myForm, which contains a ListBox control called myListBox. This ListBox has multiple columns and only one line can be selected at a time. If I click in myListBox...
  5. C

    Variable Column Selections Macro

    Hello all I'm trying to write a Macro for the following: I have a list of suppliers in column A and each month a score is generated for that supplier and the data put in columns, i.e. B has january score, C has february score etc. I want the macro to arrange the suppliers in order of the...

Watch MrExcel Video

This Week's Hot Topics

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
Top