rangea2

  1. J

    VBA Code to Center Data

    I am trying to center data in column A, C, D, and E with a macro. I am using the code below but the sort will not work so I am not sure what I did wrong. Can anyone help? Range("A2,C2:E2" & Cells(Rows.Count, "E").End(xlUp).Row) <strike></strike>
  2. J

    VBA: Cbeck cell if empty, dependent on other cells

    <tbody> Header1 Header2 Header3 Cat </tbody> Hello there, I currently have this code: Set CheckC = Range("B2") If Range("A2") = Value And Range("B2") = "" Then MsgBox "You cannot transfer until required information has been completed." & _ vbCrLf & vbNewLine & "Check for...
  3. 3

    Column Clearing Coding

    Good Day people, I was practicing some VBA questions and had hit a roadblock in the coding. The question was asking me to calculate distance between two points. My Goal was to clear the previously obtained value. However, the whole excel sheet got cleared. Here's the coding If (Range("A2") <>...
  4. B

    Split To Columns

    looking to Split Data in Column A into column b and column c. the below removes the text to the left of the coma. Thanks Sub SplitComma() Dim d As Range For Each d In Range("A2", Range("A" & Rows.Count).End(xlUp)) d.Value = Split(d.Value, ", ")(1) Next d End Sub
  5. 0

    Run-time error '381' Could not get the List Property.Invalid property array index

    Hi, I am trying to work on macro for a leave application module but that error pop out. I hope you could help me. Thanks in advance. Here is my code: Private Sub ComboBox1_Change() Sheet3.Activate Dim mytext As Long mytext = Me.ComboBox1.List(Me.ComboBox1.ListIndex) TextBox1.Text =...
  6. C

    Array - cannot paste values into diffrend ws

    Hi guys I am using an array in order to copy the values of a some cells into another sheet. Does anyone know why it breaks? Thanks in advance! Sub TrySomeArrays() Dim RollerCoaster() As Variant Dim Dimension1 As Long, Dimension2 As Long Sheet1.Activate Dimension1 =...

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