I have a button that will trigger this. It's a long macro but this is the part i want to focus on.
Dim NextRow As range
Set NextRow = wt3.Cells(Cells.Rows.Count, 1).End(xlUp).Offset(2, 0)
Do Until ctr = 3
Dim ocell As range
Dim datarg As range
On Error Resume Next
Set datarg = range("I:I").SpecialCells(xlCellTypeBlanks)
If Err Then Exit Sub
For Each ocell In datarg
If ocell.MergeCells = False Then
ocell.EntireRow.Delete
End If
Next
ctr = ctr + 1
Loop
rge.Select
range(Selection, Selection.End(xlDown)).Select
range(Selection, Selection.End(xlToLeft)).Select
range(Selection, Selection.End(xlToRight)).Select
Selection.Copy
NextRow.PasteSpecial xlPasteValues
How will i create a progress bar while that part of macro is running. I already placed ProgressBar1 in the userform.
Bookmarks