Last cell in column

M

MaryS

Here's what I'd like to do:
Go to the row after the last entry in the row before and
then go to the left by one.
For instance last entry in column C is in row 12. After
running macro would like to end up in row 13, column B.
The rows will change but the columns will always be C then
B.
I did search for this in this newsgroup but didn't find
quite what I needed to do and I don't know VBA at all.
Thanks for your help.
 
F

Frank Kabel

Hi
try something like
ActiveSheet.Cells(Rows.Count, "C").End(xlUp).offset(+1,-1).select
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Paste in column B using Last row of either column B, C or D. 10
Column number of last column that returns value ignore formulas 8
Define range by last cell in column? 3
Inaccurate LAST ROW / LAST COLUMN # 3
Help needed 0
Last Column 5
Transpose?? 6
Row and column count last occupied cells in range 2

Top