need vba help

  1. T

    Loop and save all open MS Excel Files based on cell reference

    Hi VBA experts. I found this VBA code online to save all open workbooks (Except Thisworkbook-with the code) in a predefined location with the fileName based on Cell A2. The issue is that Cell A2 (in the raw data files) has leading and trailing spaces and I needed to incorporate a CLEAN function...
  2. H

    How do I stop a userform from filling a row?

    I'm well experienced with Excel but I'm fairly new to VBA. I have a userform that will enter values into the next empty row when the "Enter" button is clicked. The issue I'm having is that, after the next empty row is filled, if the user hits the enter button again it fills the next row with the...
  3. S

    VBA problem, need help with existing code

    I had been using a code successfully for some time and the other week I had a minor change made to it in order to overcome one problem, which it did perfectly well however, in the process it created a second problem. What the code does is concatenate columns A-G into K but what makes it unique...
  4. S

    VBA help needed - For tiny adjustment to existing code

    This should be just a very minor change but I can't figure it out. Maybe someone can help. I am using an existing VBA code from a module that has worked perfectly so far. It concatenates columns A-G and puts the result in Column K. I want to keep the code doing exactly what it does performing...

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