copy range with different ranges.
 

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.

copy range with different ranges.
 

One approach:

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


"fjs" wrote:

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.

copy range with different ranges.
 

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


Tim


"fjs" wrote in message
ups.com...
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.

copy range with different ranges.
 

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

On Sat, 07 Jul 2007 20:42:56 -0700, fjs wrote:

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.

copy range with different ranges.
 

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




On Jul 7, 11:59 pm, Gord Dibben <gorddibbATshawDOTca wrote:
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



On Sat, 07 Jul 2007 20:42:56 -0700, fjs wrote:
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.- Hide quoted text -

- Show quoted text -

copy range with different ranges.
 

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

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

Gord

On Sat, 07 Jul 2007 21:19:17 -0700, fjs wrote:

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




On Jul 7, 11:59 pm, Gord Dibben <gorddibbATshawDOTca wrote:
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



On Sat, 07 Jul 2007 20:42:56 -0700, fjs wrote:
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.- Hide quoted text -

- Show quoted text -

copy range with different ranges.
 

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.




On Jul 8, 10:07 am, Gord Dibben <gorddibbATshawDOTca wrote:
Are these orders based upon a filtered list or something similar?

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

Gord



On Sat, 07 Jul 2007 21:19:17 -0700, fjs wrote:
That's the problem. The size of the range is based on orders. They
are always diferent.

On Jul 7, 11:59 pm, Gord Dibben <gorddibbATshawDOTca wrote:
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

On Sat, 07 Jul 2007 20:42:56 -0700, fjs wrote:
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.- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

copy range with different ranges.
 

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

On Sun, 08 Jul 2007 12:50:12 -0700, fjs wrote:

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.




On Jul 8, 10:07 am, Gord Dibben <gorddibbATshawDOTca wrote:
Are these orders based upon a filtered list or something similar?

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

Gord



On Sat, 07 Jul 2007 21:19:17 -0700, fjs wrote:
That's the problem. The size of the range is based on orders. They
are always diferent.

On Jul 7, 11:59 pm, Gord Dibben <gorddibbATshawDOTca wrote:
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

On Sat, 07 Jul 2007 20:42:56 -0700, fjs wrote:
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.- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -