Copying & Pasting in a Hidden Sheet

[eoinymc]

Hi,

I have the following code (which works fine when the sheet isn't hidden)

FinalRow2 = TtlRev.Cells(Rows.Count, 1).End(xlUp).Row
TtlRev.Range("AM6:AO6").Copy
TtlRev.Range(Cells(6, 39), Cells(FinalRow2, 41)).Select
ActiveSheet.Paste

However, I need to hide the sheet, but it doesn't work because you can't use .select on a hidden sheet I believe.

Has anyone got a way of doing this to a hidden sheet?

Thanks,

E

 

[VoG]

Try

TtlRev.Range("AM6:AO6").Copy Destination:=TtlRev.Cells(6, 39)

 

[eoinymc]

No, that doesn't work, because FinalRow2 is a dynamic variable.

On this particular sheet, it equals 126.

So, I am copying 1 row of data (Row 6) and then want to paste it to Rows 6-126.

Does that make sense?

Thanks,

E

 

[VoG]

Maybe (the point being that you do not need to select)

FinalRow2 = ttlrev.Cells(Rows.Count, 1).End(xlUp).Row
ttlrev.Range("AM6:AO6").Copy Destination:=ttlrev.Range(ttlrev.Cells(6, 39), ttlrev.Cells(FinalRow2, 41))

 

[eoinymc]

That works perfectly! Thanks Peter