Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select a range within a range
Hi all,
I think I'm making this harder than it really is, but I can't see any other way to do it. I have a range, where I want to select a number of rows within it. This range is very large, and I just need to select an "x" number of rows. here is the code i have. Dim x As Integer x = ((intPackNCount * 2) + intPackDCount) Dim Ra1 As Range Set Ra1 = Range("Select") Application.Goto Ra1 Range("(Ra1.Rows(1)):(Ra1.Rows(x))").Select Is there an easier way to do this? Please help. Thanks V |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select a range within a range
Dim x As Integer
x = ((intPackNCount * 2) + intPackDCount) Dim Ra1 As Range Set Ra1 = Range("Select") Ra1.Resize(x).Select just to illustrate from the immediate window: ?Range("A1:Z26").Resize(5).Address $A$1:$Z$5 -- Regards, Tom Ogilvy "nxqviet" wrote in message oups.com... Hi all, I think I'm making this harder than it really is, but I can't see any other way to do it. I have a range, where I want to select a number of rows within it. This range is very large, and I just need to select an "x" number of rows. here is the code i have. Dim x As Integer x = ((intPackNCount * 2) + intPackDCount) Dim Ra1 As Range Set Ra1 = Range("Select") Application.Goto Ra1 Range("(Ra1.Rows(1)):(Ra1.Rows(x))").Select Is there an easier way to do this? Please help. Thanks V |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using VBA to select a range within a range. | Excel Discussion (Misc queries) | |||
How can change range to select active rows instead of :=Range("S10 | Excel Discussion (Misc queries) | |||
When entering data into a range of cells, select the entire range. | Excel Discussion (Misc queries) | |||
select range and put range address in variable | Excel Programming | |||
Compare a selected Range with a Named range and select cells that do not exist | Excel Programming |