Try this.
![]()
Sub CopyBlock() Dim rngSrc As Range Set rngSrc = Range("A2", Range("G" & Rows.Count).End(xlUp)) rngSrc.copy rngSrc.Offset(rngSrc.Rows.Count).Resize(rngSrc.Rows.Count * Range("L1").Value) End Sub
Try this.
![]()
Sub CopyBlock() Dim rngSrc As Range Set rngSrc = Range("A2", Range("G" & Rows.Count).End(xlUp)) rngSrc.copy rngSrc.Offset(rngSrc.Rows.Count).Resize(rngSrc.Rows.Count * Range("L1").Value) End Sub
If posting code please use code tags, see here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks