Using Range(Range("R4"). Select to paste to cell R4

[Newfs_R_Sublime]

I am not sure what I am doing wrong here. I am trying to paste a bunch of cells to the location that's in text form in cell R1 : (A2452). R1 will be dynamic and have a different calue every time it is encountered.

Thank you

I am trying to paste C2:g275 this one time. Not that that matters

 

[Andrew Poulsom]

Does this work?

Range("C2:G275").Copy Range(Range("R1").Value)

 

[Weaver]

Could you post the code you already have please?

 

[VoG]

Try

Range("C2:G275").Copy Destination:=Range(Range("R1").Value)

 

[Newfs_R_Sublime]

The problem is that the range c2:G275 will be dynami. It may be C2:G500 next time.

Thank you, though.

 

[Andrew Poulsom]

That's a different question. What determines the size of the range?

 

[Newfs_R_Sublime]

I am sorry, I am an idiot. I put the value of the cell in R1 in :


Range(Range("R1")).Select


Thank you all so much. I am sorry about this.

Rick

 

[Newfs_R_Sublime]

Thank you so very much. I was being a complete kneebiter. Thanks