Moved Code from Worksheet Change to Command Button - Error Now

I have been staring at this for hours and can not figure out my error. Previously, I had the code below as a "Private Sub Worksheet_Change(ByVal Target As Range)". User would select from a few drop down menus on a workseet and the selections would open another worksheet in the file and unhide rows and columns where the criteria data would be. This worked perfectly. Then, it was determined that rather than automatically going to the worksheet after selecting the options from the drop downs, they wanted the ability to press a button to do the same thing. I moved the code to a macro for the button and I am getting an error message pop-up "Argument Not Optional" (error 449). I am sure it is something simple that I did wrong with simply copying and pasting the Worksheet Change code to a macro button but I can't see it. Any ideas?

Please Login or Register  to view this content.

aawww...so if I take out the target reference, I should be ok? Thank you for your reply.

Again, I simply copied and pasted from a Worksheet change sub that was looking at that row. I have been doing this for 2 days straight and I can't think. I am new to vba so all the intricacies are still a bit foreign. I appreciate your help. Thanks again and have a great day!