Last cell in column

  • Thread starter Thread starter MaryS
  • Start date Start date
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.
 
Hi
try something like
ActiveSheet.Cells(Rows.Count, "C").End(xlUp).offset(+1,-1).select
 
Back
Top