Select the cell below the last row in a table

[oliviar]

Hi Guys,
I need a macro that will select the cell right below the A column in a table.

Right after this I have a macro that puts a value into that cell, thereby increasing the size of the table automatically.
I had a macro but its not working anymore, which means it wasn't very robust.

 

[Sandeep Warrier]

Range("A" & Rows.Count).End(xlUp).Offset(1).Value = "The value you want to insert"

 

[oliviar]

Is there a way JUST to select the last cell? And not add anything to it?

 

[Sandeep Warrier]

Range("A" & Rows.Count).End(xlUp).Offset(1).Select

Note that in most cases you don't need to select things to work on them. Using select many times in the code tends to slow down the code a lot.

 

[oliviar]

Very true, however with select in this instance, I can just drop it into the middle of the rest of my macro, because I want that cell to be the beginning of a whole copied and pasted row... With the value in the macro, I would have to rewrite the whole thing!