Right() error changing columns in macro
Hi S,
Can try:
Dim rngCells As Range
With ActiveSheet
For Each rngCells In Range(Cells(1, 2), Cells(.UsedRange.Rows.Count, 2))
rngCells.Value = Right(rngCells.Value, 6)
Next
End With
Sean.
--
(please remember to click yes if replies you receive are helpful to you)
"S Himmelrich" wrote:
I get an error when I run this in a macro...what can I do.
' Convert account column
Columns("B:B").Select
Selection.Value = Right(Range("B:B").Value, 6)
|