I have a macro that is working well except when run it for the third time it duplicates all the data that is to be copied and pasted. The duplication have been shown in red in the attached file. Also I have noticed the formating in the column with "No Month" entry is not the same as the first copy as shown for "September" month color "Green".
Can anyone look at the code and see if their is any obvious problem.
My second problem is how can I format the interior of the cell in the similiar code as shown below:
rngDst.Offset(LastRow, 3).PasteSpecial xlPasteValues
With rngDst.Offset(LastRow, 3).Resize(rngSrc.Rows.Coun
.HorizontalAlignment = xlRight
I would like to use the code below to the code above:
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
.Color = 16777157
.TintAndShade = 0
.PatternTintAndShade = 0
Can anyone solve the two problems please.