rng1

  1. B

    Run-time ERROR 13 Type Mismatch

    Yes, that old chestnut.... Excel 2013 Been using this macro for around 7 years on a membership database with no problems whatsoever. Checks data in "current" sheet and adds/changes to corresponding cells in "archive" sheet Yesterday as usual added a couple of new members to "current" ran macro...
  2. M

    Carriage Return Not Needed

    I am attempting to write to a txt file in excel from two separate ranges in 2 different sheets. Below is the code that works, but it leaves a carriage return at the end of the txt file that I cannot have when importing into our software. Could anyone be able to help a VBA beginner out with this...
  3. D

    VBA help with cell value

    Hi, I am trying to get the data from one cell value and add it to another cell value but the result i keep getting is just one cell value being added to all the other cells values, can someone help please. Dim Rng1 As Range, i As Range, Rng2 As Range, x As Range, a As Range, b As Range...

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