View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_7_] Bob Phillips[_7_] is offline
external usenet poster
 
Posts: 1,120
Default Selecting The Last Row

He is asking to get the last row in any columns A-W.

--
HTH

Bob Phillips

"Jef Gorbach" wrote in message
...

"Minitman" wrote in message
...
Greeting,

I need to select columns A thru W on the last filled row. I know that
Range("A65536").End(xlUp) will get me to the first cell of the last
row, but how do I get from first cell to A thru W?

Any help would be appreciated.

TIA

-Minitman


range("A65536").end(xlup).entirerow.select