or using right instead
![]()
Sub test() For Each Rng In Range("A1:a5") Rng.Offset(, 4) = Right(Rng, Len(Rng) - InStrRev(Rng, "/")) Next End Sub
or using right instead
![]()
Sub test() For Each Rng In Range("A1:a5") Rng.Offset(, 4) = Right(Rng, Len(Rng) - InStrRev(Rng, "/")) Next End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks