Hi guys,

I have a problem.

My data in row 3 starts from different cells all the time,i.e.,
sometimes from g3, fg3, etc.

i have some data in row 4 (the number os values here is also
variable) which i want to place right of where the data starts in
row3,e.g,

row3

blank blank blank blank blank blank blank blank 4 2 3

row4

1 2 3

After the operation I want row3 to look like this

blank blank blank blank blank 1 2 3 4 2 3

I hope I have been able to explain the problem.

Would really appreciate any help and guidance.

Thanks

ali

On Jul 29, 4:13 pm, ali wrote:
Hi guys,

I have a problem.

My data in row 3 starts from different cells all the time,i.e.,
sometimes from g3, fg3, etc.

i have some data in row 4 (the number os values here is also
variable) which i want to place right of where the data starts in
row3,e.g,

row3

blank blank blank blank blank blank blank blank 4 2 3

row4

1 2 3

After the operation I want row3 to look like this

blank blank blank blank blank 1 2 3 4 2 3

I hope I have been able to explain the problem.

Would really appreciate any help and guidance.

Thanks

ali

Sorry mates,

I want the data in row 4 to appear left of data in row 3. A mistake.
my apologies.

ali

On Jul 29, 11:16 am, ali wrote:
On Jul 29, 4:13 pm, ali wrote:





Hi guys,

I have a problem.

My data in row 3 starts from different cells all the time,i.e.,
sometimes from g3, fg3, etc.

i have some data in row 4 (the number os values here is also
variable) which i want to place right of where the data starts in
row3,e.g,

row3

blank blank blank blank blank blank blank blank 4 2 3

row4

1 2 3

After the operation I want row3 to look like this

blank blank blank blank blank 1 2 3 4 2 3

I hope I have been able to explain the problem.

Would really appreciate any help and guidance.

Thanks

ali

Sorry mates,

I want the data in row 4 to appear left of data in row 3. A mistake.
my apologies.

ali- Hide quoted text -

- Show quoted text -

To find the last non-empty cell going right, you can use
Selection.End(xlToRight).Select.

Wow, you really don't pay attention to the responses you get, do you? I
posted a detailed response of why cross-posting (as opposed to
multi-posting) is the way to ask your questions in more than one newsgroup,
and that post even showed you how easy it is to perform a cross-post, and
here you are multi-posting your current question. Any particular reason why?

Rick


"ali" wrote in message
ups.com...
On Jul 29, 4:13 pm, ali wrote:
Hi guys,

I have a problem.

My data in row 3 starts from different cells all the time,i.e.,
sometimes from g3, fg3, etc.

i have some data in row 4 (the number os values here is also
variable) which i want to place right of where the data starts in
row3,e.g,

row3

blank blank blank blank blank blank blank blank 4 2 3

row4

1 2 3

After the operation I want row3 to look like this

blank blank blank blank blank 1 2 3 4 2 3

I hope I have been able to explain the problem.

Would really appreciate any help and guidance.

Thanks

ali

Sorry mates,

I want the data in row 4 to appear left of data in row 3. A mistake.
my apologies.

ali