| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB Script XL - Range Selection
I'm new to Scripting in Excel and trying to select a Range of cells beginning
at B13... want to End-down and then go right 23 cells and have that range active to print... Closest I've come is Range ("B13".End(xlDown)).Right 23.Activate {I've thrown in Right 23 as I don't know how to include that part}... thanx in advance... |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VB Script XL - Range Selection
Try
Range("B13").End(xlDown)(1, 24).Activate Cordially, Chip Pearson Microsoft MVP 1998 - 2010 Pearson Software Consulting, LLC www.cpearson.com [email on web site] On Tue, 2 Feb 2010 13:59:01 -0800, Servant63 wrote: I'm new to Scripting in Excel and trying to select a Range of cells beginning at B13... want to End-down and then go right 23 cells and have that range active to print... Closest I've come is Range ("B13".End(xlDown)).Right 23.Activate {I've thrown in Right 23 as I don't know how to include that part}... thanx in advance... |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VB Script XL - Range Selection
Close :) Split the command in two, first get the last row:
Lastrow = Range(Cells(13,ColNbr),Cells(13,ColNbr)).End(xlDow n).Row Then go right: Cells(Lastrow,ColNbr+23).Activate "Servant63" wrote: I'm new to Scripting in Excel and trying to select a Range of cells beginning at B13... want to End-down and then go right 23 cells and have that range active to print... Closest I've come is Range ("B13".End(xlDown)).Right 23.Activate {I've thrown in Right 23 as I don't know how to include that part}... thanx in advance... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change InputBox Range Selection to Column Letter Selection | Excel Programming | |||
| Range(Selection, Selection.End(xlToRight)).Select | Excel Programming | |||
| VB Script based on combobox selection | Excel Programming | |||
| Line selection from a cell script through a VBA macro | Setting up and Configuration of Excel | |||
| Excel VBA - Range(Selection, Selection.End(xlDown)).Name issue. | Excel Programming | |||
Linear Mode
