K
Kathy in Cincinnati
I need to pick four non-contiguous cells in a row, copy
them and then paste their values into a column
using 'paste special', 'value', 'transpose'. The
worksheet has one row of data, four rows for summary,
another row of date, four more rows for summary etc.
I can do this easily by clicking the four cells using the
mouse while holding down the control key, but I can't
find a way to do this that the macro recorder will
recognize.
Does anyone have a solution? Thank you. Kathy
them and then paste their values into a column
using 'paste special', 'value', 'transpose'. The
worksheet has one row of data, four rows for summary,
another row of date, four more rows for summary etc.
I can do this easily by clicking the four cells using the
mouse while holding down the control key, but I can't
find a way to do this that the macro recorder will
recognize.
Does anyone have a solution? Thank you. Kathy