Try this macro
![]()
Sub Macro1() Dim LR As Long LR = Range("A" & Rows.Count).End(xlUp).Row Range("A1:D" & LR).Cut Range("H1") Range("A1:D" & LR).Delete Shift:=xlToLeft End Sub
Try this macro
![]()
Sub Macro1() Dim LR As Long LR = Range("A" & Rows.Count).End(xlUp).Row Range("A1:D" & LR).Cut Range("H1") Range("A1:D" & LR).Delete Shift:=xlToLeft End Sub
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks