finding empty cell and enter data from right to left
 

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

finding empty cell and enter data from right to left
 

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

finding empty cell and enter data from right to left
 

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.

finding empty cell and enter data from right to left
 

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