How to select the last cell in a currently selected range

The following code selects all cells from Q12 through the last data row of database.

Let's assume the last row of data is row 300. After the cells of Q12 thru Q300 are selected, I want the active cell to be 1 cell below the last data row. The previous selection is then no longer needed.

My request is for a diffeent need, than what this code is used for else where..

Please Login or Register  to view this content.

Thanks for the help
Matt

Try this,

Please Login or Register  to view this content.

A quick way to select the first empty cell in column Q by looking UP from the bottom of the worksheet:

Please Login or Register  to view this content.

Thanks for the try. I forgot to say that there are blank cells in various cells, so I can't use either method. I happen to know these two ways, but I don't know how to get around the blank cells. The sample code I'm using selects all cells including empty cells, all the way down to and including the last data row of the database.

Please take another look

Thanks

Matt

Hello Matt,

A minor change is all that is needed.

Please Login or Register  to view this content.

Good Morning Leith . . . Good To See Your Name

Only 1 problem . . .

Column Q does not always have data in any particular cell. There currently happens to be 8 blank cells in column Q at the bottom. Some cells in Column Q will never have data. This causes me a problem, as I need to have the last data row, in column Q, selected. Then, I can move the selection down 1 cell and then move it to column "A" on the same blank row or record.

I need this macro so that I can add a new record in the 1st row after the current data row.

Hope that I have explained this to where it can be understood.

Thanks Much

Matt

Hello Matt,

You are up early this morning. If "Q" extends to the end of the database then maybe this change is what you need. This will select one row below the last row of the database.

Please Login or Register  to view this content.

You should avoid 'Select' & 'Activate' in VBA

you could use:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

Hi Leith . . .

I copied and pasted your code and as I press F8 to start stepping thru, I get a VB Compile error: Method or data member not found. The code Set Rng = Wks.cell(RngEnd.Row + 1, "G") has the .cell high-lited.

Thanks Again
Matt

Hello Matt,

Looks like my bad typing skills are to blame.

Please Login or Register  to view this content.

Right on the Money

I added

Please Login or Register  to view this content.

and the cell selected is column A same row as you 1st selected.

Many Thanks

Matt