hi,
copying some data(value+formulas) and pasting to the same sheet but the problem is that this is taking long time to do work, so i need a better version to do this task.
![]()
Sub OL_FORMULA_COPY() Sheets("OL").Activate Dim lCalc As Long Dim i, j, count Application.ScreenUpdating = False lCalc = Application.Calculation count = WorksheetFunction.CountIf(Sheets("OL").Range("AP4:AP100"), ">0") - 1 i = 89 For j = 1 To count Range("A4:AN88").Copy '253 Range("A" & i).PasteSpecial Paste:=xlPasteAll i = i + 85 Next j Application.Calculation = lCalc Application.ScreenUpdating = True End Sub
Bookmarks