Macro for selecting every other row

[learninman]

Hi,
Im new to VBA and have come into a few instances where I have tried, unsuccessfully, to create a macro that will select every other row and then copy that selection. What I have been settling for is holding control and selecting whatever rows I need to copy but I am curious to know if it is possible to code this.
please let me know,
thanks

 

[learninman]

hey Rick,
this works great! thank you!
as I am trying to understand and learn I was wondering if you could point me in the right direction of understanding some of the code...
I tried searching for What:="*" as I have no idea what it referes to (I do not know what "what" does or "*") but recieved no results on this forum or on google so any help to point me in the direction of where I can learn about this would be great
again, thank you