Excel copy / paste help needed 1

[Henryk]

Hi all,

no amount of analysing recorded macros has helped me to figure out how to do what I need, so please can someone help?

I have sheet names in row 2. Let's say my active cell is row 5 column 7. I want to copy cells a5:e5 from the sheet name stored in column 7 row 2 to sheet display row 1 column 1.

I actually need to do a lot more but an answer to this will point me in the right direction..

Thanks,
H

 

[SkipVought]

Hi,

"I have sheet names in row 2. Let's say my active cell is row 5 column 7. I want to copy cells a5:e5 from the sheet name stored in column 7 row 2 to sheet display row 1 column 1. "

ActiveSheet.Range(Cells(ActiveCell.row, "A"), Cells(ActiveCell.row, "E")).Copy Sheets(Cells(2, ActiveCell.Column).value).Cells(1,1)

Skip,

_[red][/red]

 

[Henryk]

Thanks Skip

H