finding empty cell and enter data from right to left

[ali]

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

 

[ali]

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

 

[mjones]

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.

 

[Rick Rothstein \(MVP - VB\)]

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