View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default Extend range from A4 to last column

Range(range("A4"), cells(4, columns.count).end(xltoleft)).select
--
HTH...

Jim Thomlinson


"CEG" wrote:

All I need is to select the range from A4 to the last used column in row 4.

This should be easy. There are plenty of posts about extending to the last
row, and I can't seem to make the transition to "last column" work.
--
CG