Small Macro edit is causing pasting nightmare

[Shawn_L]

So I have a macro that copies a range in a row, selects another tab, finds the first empty row and paste the values in the same number of columns that it copied. It then goes back to the original tab and clears the copied values. This has worked great for month but now I have added an additional cell in the same row for it to copy and paste in the other tab. I went into the macro and simply changed the range from B5:P5 to B5:Q5. But now when it pastes on the other tab it repeats the pasted continuously over and over again down the selected row??? I did not change a thing about the paste instructions and it still does all of the other commands perfectly. I'm at a lost for how adding that one cell in the range has caused it to somehow repeat the paste down the correct row I need it to. I only need it to paste the values once per row as there are adjacent columns with formulas in them to calculate the data but now they are getting wiped out and changed to the repeated paste values. What am I missing???

[TMS]

What am I missing???

Pretty difficult to know without seeing the code (and workbook).

[Shawn_L]

Sub EIGHTDF()
'
' EIGHTDF Macro
'

'
Range("B5:P5").Select changed P5 to Q5 and now it will repeat the paste horizontally in the last row over and over again.
Selection.Copy
Sheets("VERT 8 DF").Select
Range("A1").Select
Selection.End(xlDown).Offset(1, 0).EntireRow.Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("ALL VERTICAL").Select
Range("A1").Select
Selection.End(xlDown).Offset(1, 0).EntireRow.Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("INPUT").Select
Range("J5:K5").Select
Range("K5").Activate
Application.CutCopyMode = False
Selection.ClearContents
Range("H5").Select
Selection.ClearContents
End Sub

[TMS]

I'd try changing

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional.)