Make last cell in currentregion the activecell

[Guest]

I need some code to make the last cell in the currentregion the active cell

Grateful for any help.

 

[stevebriz]

check this page out.

http://www.ozgrid.com/VBA/ExcelRanges.htm

 

[Dave Peterson]

with selection.currentregion
.cells(.cells.count).activate '.select?
end with

 

[Guest]

Dave

Just the job!

Thanks

with selection.currentregion
.cells(.cells.count).activate '.select?
end with