I'm trying to copy and paste special (values) into my active file.
The # of rows in this file will change so it won't be static all the time.
Can anyone point me in the right direction on how to set this up in vba?