Get a range of cells from a selection of Rows
Thanks, David. Appreciate it.
"David McRitchie" wrote:
Hi Dan,
You would have to paste into a single cell in Column A,
and the out receiving range would be expanded accordingly.
You would have to paste to Column A because that is the
only way the number of columns will match.
"danhattan" wrote...
My subject line may have caused confusion. It should have read "selection of
Rows".
Because my code captures entire rows, all the way from column A to column
IV, I can't paste into a range of cells. I have to paste into a corresponding
number of selected rows. Thus my dilemma. Sorry about the typo in the subject
line, and thanks for looking at it. That said, any additional thoughts on how
to change the selection of entire rows to just a range of columns within the
entire row?
|