rangea2

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>

<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...

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") <>...

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

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 =...

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 =...