| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select Range
Hi all, how can i select range from B2 to last value cell to left in
row 1 by macro. please can any body can help |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Select Range
Sub selectrange()
Range(Cells(2, 2), Cells(2, Cells(1, Columns.Count) _ .End(xlToLeft).Column)).Select End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "K" wrote in message ... Hi all, how can i select range from B2 to last value cell to left in row 1 by macro. please can any body can help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can change range to select active rows instead of :=Range("S10 | Excel Discussion (Misc queries) | |||
| macro to select range from active cell range name string | Excel Programming | |||
| When entering data into a range of cells, select the entire range. | Excel Discussion (Misc queries) | |||
| Compare a selected Range with a Named range and select cells that do not exist | Excel Programming | |||
| Select Sheet then Select Range | Excel Programming | |||
![K[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
