copy range with different ranges.

[fjs]

How do I make a marco to copy one cell in to many cells without
knowing the starting of the range?

The start of the range will always be different, and the cell to be
copied will always be different.

EX: this time copy a1 to a2:a28

next time copy a5 to a6:a28

and the next time it could be a54 to a55:a150


The start of the range will always be the next cell that is being
copied.

Thanks.
Frank.

 

[Guest]

One approach:

With Range("A1")
.Copy .Offset(1,0).Resize(27, 1)
End With

 

[Tim Williams]

Dim rng As Range
Set rng = ThisWorkbook.Sheets("Sheet1").Range("A5:A33") 'or whatever
rng.Value = rng.Cells(1).Value


Tim

 

[Gord Dibben]

With great difficulty based upon those parameters.

You don't know the cell to copy nor the range to copy to.

Is there anything that could determine which cell to copy?

I see your pattern for the start point of the range to copy to but what would
determine the size of the range from there?


Gord Dibben MS Excel MVP

 

[fjs]

That's the problem. The size of the range is based on orders. They
are always diferent.

 

[Gord Dibben]

Are these orders based upon a filtered list or something similar?

How do you currently select what data to copy and paste manually?

Gord

 

[fjs]

Everything is copied and pasted manually right now. The orders are
based on a production run.
When(if) production gets behind, that is why the cell to get copied is
different, and the size of the to copied to range is also different.

 

[Gord Dibben]

I am unable to give you any pointers based on the information you have given in
this post or earlier postings.

Only you know which cell to copy and to where.


Gord