application.union

  1. M

    worksheet_change problems

    Hi guys, I've written some code to protect certain ranges from unnoticed editing. unfortunately its not working yet. Ranged H9 - X(COUNTED nr) must activate the macro. Sub worksheet_change(ByVal Target As Range) Dim rng As Range Dim R As Long Dim txt As String 'count used cells R =...
  2. J

    Combine headers from two sheets onto a third

    This is using Excel 2013 and VBA. The goal of the project is to take data from sheet A and find matches on either sheet B or sheet C and build sheet D or sheet E based on matches between A+B or A+C. The use of match and looping are taking care of the data, but I need to combine the headers...
  3. Darren Bartrup

    Importing union range into Access.

    Morning all, I've been working on importing an Excel worksheet into Access allowing for the fact that the number of columns in my worksheet will change (so I can't have a single table with x number of fields). The worksheet is basically a work count for the team; I've got 10 columns that...

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