Hi,
I want to make this code work more faster.Actually this code is for adding rows below a already existing table.The table has conditional formatting and Data validation.
for that only I have used the copy and paste.
I have already used Application.ScreenUpdating = False
in the begining of the code.
In the below code "x" is for number of rows to be inserted.If 2 has to be inserted means then the code runs 2 times and so 2 rows are inserted.
For ins = 1 To x
Selection.Insert Shift:=xlDown
'added 29082013
Rows(j).Select
Selection.Copy
Rows(i).Select
ActiveSheet.Paste
Application.CutCopyMode = False
Selection.ClearContents
'added 29082013
Next ins
Bookmarks