Hi
maybe
activecell.resize(1,11).copy

--
Regards
Frank Kabel
Frankfurt, Germany

Dean wrote:
I am attempting to copy a range of cells in a macro. Each time the
macro is run the columns remain the same but the rows are different
each time. I am able to move the active cell to column A of the
wanted row but want to select cells from A through K in that row only
to copy. Am a complete novice to Office programming. Help