canvcsixteen
04-24-2013, 11:23 AM
A novice to VBA -- I have exhausted my few resources (two beginner texts!) and now resorting to the experts.
I am want to copy and paste a range of cell to another to sheet (which I know how to do), however IF the there are values in the targeted paste cells, than paste to a new column or the next empty column to the right.
Is this difficult? Can anyone help?
I am want to copy and paste a range of cell to another to sheet (which I know how to do), however IF the there are values in the targeted paste cells, than paste to a new column or the next empty column to the right.
Is this difficult? Can anyone help?