| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extend range from A4 to last column
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Extend range from A4 to last column
Perfect! (I had the right elements, just had them in the wrong order.)
-- CG "Jim Thomlinson" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extend a Range | Excel Programming | |||
| Extend Name range | Excel Discussion (Misc queries) | |||
| HOW TO EXTEND A NAMED RANGE | Excel Worksheet Functions | |||
| Painting Range - extend the range on the top part | Excel Discussion (Misc queries) | |||
| Extend a data range | New Users to Excel | |||
Linear Mode
