Rows.Count, (??) - Variable Column Index

[rodgersmg]

Im using Rows.Count...End(xlUp) to find the last empty row, but am getting hung up on the column index. THe Problem is, if I use "A" as the column (Rows.Count,1), and theres something in column B in the row below, I end up pasting over it unintentionally.
I'm sure there's a simple way around this, but Google hasn't been very forthcoming as of yet...

Clues?

[Philb1]

When I do ranges I usually do them this way. This will set a range called SomeRange on column A from row 5 to the lowest used row on column A.
It depends on how many times you want to use the range. If it a one off use the bottom example. I made it colour the cells green to give you an idea
cheers

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[rodgersmg]

Ok, Thing is I don't always know which column will have the last filled cell.
It's part of that last code you help me with () where I wanted to Loop forever..

Looks like I sussed it though:

Please Login or Register  to view this content.

Nice to see another Kiwi working late though

[Philb1]

Hi rogersmd
Try using this code. It's basically the same with the main difference being finding the bottom row wherever it is on the worksheet & using that row instead of rows.count
I'm not working as such, I do this for fun really. About 3 or 4 years ago the only thing I knew about a spreadsheet was the fact it was a screen full of rectangles. Then one day I had a use for one & started the learning curve.

Please Login or Register  to view this content.