rcell.value

  1. H

    Comibine multiple lists, creating a unique list on a seperate worksheet/workbook, using VBA.

    Hi, I am a complete beginner at VBA. I have a spreadsheet containing 19 columns (lists), which I need to combine into one unique list (in either a separate column in the same Sheet, or on a separate sheet, or even separate workbook. There is duplicates across all of the columns, so duplicates...
  2. A

    Read any leading comma in Cell in VBA UDF

    I'm still having trouble with this... found this code Sub AddCommaToESIID() Dim rCell As Range If TypeName(Selection) = "Range" Then For Each rCell In Selection.Cells If Not rCell.HasFormula Then rCell.Value = "," & rCell.Value End If...
  3. K

    Alternative Loop

    Hi All, I have the below VBA code which does what I need but it is very slow. Can someone tell me if there is a way this can be done in one step rather than looping through all 2500 cells. Application.ScreenUpdating = False Dim Current_Date As Date Dim Date_String As String...
  4. J

    Input 4 digits into a cell, convert to [mm]:ss

    Entering time values complete with colons is time consuming. I am hoping to find a solution to this by being able to enter a four digit number (i.e. 6609) which will be converted to 66:09 in [mm]:ss format. The times then can be used in calculations. I have the following code which works well...
  5. J

    VBA to replace first four digits of a phone number using regex

    Can anyone help me amend this snippet to instead of adding periods to break up a phone number to replacing the first four digits with an "x"? Thanks, J Sub SymbolsInPhN() Dim rRng As Range, rCell As Range Set rRng = Range("A2", Range("A" & Rows.Count).End(xlUp)) With...

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