Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
define end column in a range
I would like to accomplish two things in vb code:
1) create a variable that defines the last column of a given range (i.e. lastcol = ?). 2) Then use the variable as part of a selected range (i.e. Range("A1:lastcol") |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
define end column in a range
One way, among many:
If the variable rng is set to your given range: Dim lastCol as Integer LastCol = rng(rng.Count).Column To use (again, one among many): Dim newRange As Range Set newRange = Range("A1").Resize(1, lastCol) or Dim newRange As Range Set newRange = Range(Cells(1, 1), Cells(1, lastCol)) In article , "Chris Perry" wrote: I would like to accomplish two things in vb code: 1) create a variable that defines the last column of a given range (i.e. lastcol = ?). 2) Then use the variable as part of a selected range (i.e. Range("A1:lastcol") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Define Name range | Excel Discussion (Misc queries) | |||
Define a range by searching for first and last? | Excel Discussion (Misc queries) | |||
Define a range | Excel Discussion (Misc queries) | |||
Define a range based on another named range | Excel Worksheet Functions | |||
Define Range with an offset | Excel Discussion (Misc queries) |