Macro under button that looks at a specific cell in the row and fills other cells

[zjef]

Hi guys,

it's almost all in the title;

How would a macro look if column Z contains a string and I want columns AA to show the first 2 characters and column BB to contain the rest of that string.

I know this can easily be done with a formula but the working macro I have is too complex and uses live xml data so I prefer to work with a simple example instead of posting it here.

I don't know the basics of VBA but have experience in coding so I can alter code but am not good at writing it from scratch.

I'm just looking for a quick answer on how to
-have a macro look at a specific cell in the current/selected row and
-fill specific other cells in that same row using code that I already have so anything will do for this example

Thank you so much!

[Neil_]

Something like ...
For a specific string

With ActiveCell.EntireRow
   If .Cells(1, "Z") Like "Little Red*" Then
      .Cells(1, "AA") = Left(.Cells(1, "Z"), 2)
      .Cells(1, "BB") = Right(.Cells(1, "Z"), Len(.Cells(1, "Z")) - 2)
   End If
End With

Edit: fixed missing bracket

For any string

With ActiveCell.EntireRow
   If Len(.Cells(1, "Z"))>0 Then
      .Cells(1, "AA") = Left(.Cells(1, "Z"), 2)
      .Cells(1, "BB") = Right(.Cells(1, "Z"), Len(.Cells(1, "Z")) - 2)
   End If
End With

[zjef]

Perfect! thanks so much!