How to refer to a selected range

[hogstrom]

Hi everyone,

I'm trying to create a macro that copies the cells that I currently have marked.

Example: I select the cells C5:F13 (by marking them with the cursor) and the macro copies this range. If i after this selects G2:R15, the macro will copy this range....

I have searched for a solution but cannot find one, and I know there is one!

I hope this makes any sense and I'm looking forward to a solution!

/E

 

[SkipVought]

This is a duplicate thread, and is being handled in forum707.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]