If your intent is to extract the diagonal cells into a continuous col range
eg: A1, F3, K5 ... (you probably had a typo in your post: "K4")
here's one way which makes it a breeze, and dynamic, too ...

Assume your source data is in Sheet1
In another sheet, in any startcell, say in B2:
=OFFSET(Sheet1!$A$1,ROWS($1:1)*2-2,ROWS($1:1)*5-5)
Copy down as far as required to extract as required
Adapt easily to suit:
Sheet1!$A$1 is the top left cell in the source sheet
The ROWS bits of it in the expression is aligned to the down 2x1, across
5x1, then down 2x2, across 5x5, etc, ie the zigzag path that defines the
diagonal cells A1, F3, K5 ... Success? Immortalize this response, zonk the
YES below
--
Max
Singapore
---
"A." wrote:
I would like to copy cells in an excel worksheet following this pattern: e.g.
A1, F3, K4 etc. Is it possible to mark the cells and then copy them all at a
time?