try to Copy entire Row if active cell equals variable

Hi Mfederman

Welcome to the Forum.
In future please view the forum rules before posting. Your post does not comply with rule #3.

3. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the [#] button at the top of the post window.

Would be ideal to see a sample workbook. Start with changing this line of code

Range.Offset(0, -5)activecell.end (xltoright).Copy

to

Range.Offset(0, -5).EntireRow.Copy

Are you wanting to copy all the rows that match the payroll input date to a new workbook.
Your variable

Dim payrolldate As Range

is giving the error