Make last cell in currentregion the activecell
 

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

Grateful for any help.

Make last cell in currentregion the activecell
 

check this page out.

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


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

Grateful for any help.

Make last cell in currentregion the activecell
 

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

Snowsride wrote:

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

Grateful for any help.

--

Dave Peterson

Make last cell in currentregion the activecell
 

Dave

Just the job!

Thanks

"Dave Peterson" wrote:

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

Snowsride wrote:

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

Grateful for any help.

--

Dave Peterson