Maybe:
![]()
Sub JhonMustofa() Dim rcell As Range For Each rcell In Range("C2:C" & Range("C" & Rows.count).End(3)(1).Row).SpecialCells(xlCellTypeVisible) rcell.offset(, 1).Value = rcell.Value Next rcell End Sub
Maybe:
![]()
Sub JhonMustofa() Dim rcell As Range For Each rcell In Range("C2:C" & Range("C" & Rows.count).End(3)(1).Row).SpecialCells(xlCellTypeVisible) rcell.offset(, 1).Value = rcell.Value Next rcell End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks