filling up excel row

[amateur1902]

Hello everyone,

I would like to know the following,

What formula do i need to perform the folowing actions.

When i've got column A It happens that my data is misplaced in different rows. I would like to have a formula that searches down column A10 and finds the first filled row. When it finds the first filled row, then it has to select al of the filled columns downwards. This way i can make it possible to cut and paste the row into A10. Now my row always starts from A10.

But i never know where the first column is going to be filled.

I hope this question is clear to you all,

Thanks
http://www.mrexcel.com/forum/images/misc/progress.gif

[Bob Phillips]

Not clear. Give an example.

[Ago]

its very confusing what you wrote. i think you are getting it mixed up, columns is the ones named A, B, C, D... and so on, and rows are numbered.

but is it correct that you want a script that marks the first cell in A-column that is higher than row 10 (A10 and below) to the last cell in A-column that is filled?

something like this?



Sub test()

Range("A10").Select
Range(Selection.End(xlDown), "A" & Cells(Rows.Count, 1).End(xlUp).Row).Select
End Sub

[Bob Phillips]

I will ignore all cross-posts as I keep saying, so it helps me to know.

[amateur1902]

Hi,

Thanks for youre help but i solved the problem.

Now i use a msg box when the cell is empty. So now when the user does something wrong can't go any further.

Thanks.

[Aussiebear]

Any chance you could post your workbook? I had to re read your initial post a few times, but then your second post is akin to whistling at a girl in the dark... you know you are doing so, but she doesn't.

No offense but that post of yours belongs in the Rubic's Cube section.