Hi
I have a little macro that copies values from one column to another then returns the first column to zero, what I would like to achieve is every time I run the macro it either asks me which column I wish to paste value into or auto progresses through the column i.e. B Then C then E each time in runs
Preferably the first where it asks me which column to paste the ranges into



Sub copy_hours()
'

Worksheets("sheet1").Range("a1:a20", "a22:a44").Copy
Worksheets("sheet1").Range("c1", "c22").PasteSpecial Paste:=xlPasteValues

Dim Rg As Range
Set Rg = ActiveSheet.Range("a1:a20", "a22:a44")
Rg.Value = 0

End Sub
could anyone suggest how I might achieve this