Macro to copy cells from a selected range and just paste values back to that same range

whats up everybody.

I am currently trying to write a VBA macro that will allow me to use a button click to copy a selected range and paste only values in that same selected range. I am using a today() function and it will change the date come tomorrow, and I do not want the dates to be changed for today.

It will vary by day between 1 and 100 so I figure the best way is just have a user select the range and just turn that range into values only so it keeps by date, but will keep my formula in the rest of the column.

If you need me to send what I currently have, let me know, but it does not work lol

THANKS IN ADVANCE!!!!

This is exactly what I am after, but instead of using cells "A1:H24", can I make it so cells A1:H24 can be selected by the user highlighting a specific group of cells?

.
If you want the User Selection method, use Mumps macro. I've added something to clean up the view after
pasting :

Please Login or Register  to view this content.

PERFECT, thank u, I knew it must have be easy, I have not learned Selection before, will that always use highlighted cells?