Maybe I am going about this wrong. What I have so far is the following that was provided by this site on an earlier question.
Dim r As Range
'right oneFor Each r In Range([b12], [b12].End(xlDown))
For Each r In Range([b12], [b12].End(xlDown))
Range(r, r.Offset(0, 4)).Copy [s30]
Range(r, r.Offset(0, -1)).Copy [r30]
'now do the other stuff.
The above is used to run thru the column b starting at row 12 and copy the cell and the 4 cells to the right of it and one cell to the left of it and copy them to a location s30 and r30. After they are in r30, I have a userform that refers to those cells and then I print the userform. Then I clear the r30& s30 and do it all over again until I run out of data in the column.
What is going to happen is that future rows are going to be added to Range b12 on down and I need to not redo all the copying of the ones that I just did and just do the newly added ones without clearing the cells of the old ones. I figure if I can mark the adjacant cells, I can setup a print command button that will print by referencing the adjacnt cell in the next column rather than the orginial one.
I am sorry this is so drawn out. I appreciate this site immensely and all your help.
Todd
Dim r As Range
'right oneFor Each r In Range([b12], [b12].End(xlDown))
For Each r In Range([b12], [b12].End(xlDown))
Range(r, r.Offset(0, 4)).Copy [s30]
Range(r, r.Offset(0, -1)).Copy [r30]
'now do the other stuff.
The above is used to run thru the column b starting at row 12 and copy the cell and the 4 cells to the right of it and one cell to the left of it and copy them to a location s30 and r30. After they are in r30, I have a userform that refers to those cells and then I print the userform. Then I clear the r30& s30 and do it all over again until I run out of data in the column.
What is going to happen is that future rows are going to be added to Range b12 on down and I need to not redo all the copying of the ones that I just did and just do the newly added ones without clearing the cells of the old ones. I figure if I can mark the adjacant cells, I can setup a print command button that will print by referencing the adjacnt cell in the next column rather than the orginial one.
I am sorry this is so drawn out. I appreciate this site immensely and all your help.
Todd