Any way I can record a single macro that selects and copies multiple ranges?

[callous]

Assuming value “1” is in A1, how can I select A1:C5 and D1:E5, and record the macro? I tried doing it but it’s only selecting A1:C5 when I run it.

-----+-----+-----+-----+-------
|  1  | 100 |  A  |  1  |  .1 |
  -----+-----+-----+-----+-----
|  2  | 200 |  B  |  0  |  .1 |
  -----+-----+-----+-----+-----
|  3  | 300 |  C  |  0  |  .1 |
  -----+-----+-----+-----+-----
|  4  | 400 |  D  |  1  |  .2 |
  -----+-----+-----+-----+-----
|  5  | 500 |  E  |  0  | .03 |
-----+-----+-----+-----+-------

[fpy]

@callous

A1:C5 and D1:E5

why not directly A1:E5 ?

[robleyd]

You might want to read Recording a Macro, particularly the limitations.