Forum Discussion
Solved
Get Macro to copy/paste values only after running in what was active cell
I have a pretty basic macro to create a unique ID for a sales file Once it's done that , I want to copy then paste special (values only) to hard wire the random ID However , it does the fir...
shotgun-68 Instead of Range("B12").Select use ActiveCell.Select . That should work, though, I've not been able to test it.
shotgun-68 Instead of Range("B12").Select use ActiveCell.Select . That should work, though, I've not been able to test it.
Riny_van_Eekelen , thanks , worked perfectly
