Selecting a range
 

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

Selecting a range
 

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