mystr

  1. I

    Merge 2 codes into 1

    Hi, Can you please advise the way to merge the following codes. Then i will have the 1 button the press to run both codes. Many Thanks for all your help. Sub LEADERBOARD() '' leaderboard Macro' Range("C1:F17").Copy Range("I1") Worksheets("HONDA SHEET").Range("C1:D17").Copy...
  2. I

    Set my range help please

    Evening, I have the code installed below but need advice for the correct way to writ something if i may ask. The part im stuck with is Set my Range, the sheet is called SOLD ITEMS & the range is C2:C35 Thanks Private Sub CommandButton1_Click()Dim myData Dim myStr As String Dim x As Integer...
  3. D

    VBA Remove Duplicates letters from cell

    Hi, I am trying to remove duplicate letters from cells, however the code below works fine on letters but when there are numbers involved it doesn't end well. What I would like to do is remove all duplicate letters from a cell even if there are numbers present. Can someone help with this. Sub...
  4. D

    VBA Merge cells comma delimited

    Hi, i am trying to merge cells together comma delimited, I am almost there but need help, Can someone help with this please. Sub MergeCommaDel() ' Dim objSelection, objCell As range, MyStr As String Application.ScreenUpdating = False On Error Resume Next Set objSelection =...

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