Selecting range with variable row length

[rrrdavis07]

I have a range of data from a1:g-. The number of rows in this range vary. I need to be able to select only columns c:f and only the rows that are part of the CurrentRange. Put another way, I need to select only certain contiguous columns from the CurrentRange. I'd appreciate anyone pointing out how to do this.

Randy Davis
Denver, CO

 

[PHV]

Have a look at the Intersect method.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[rrrdavis07]

I was able to figure out the solution:

RowCount = Range("A3").CurrentRegion.Rows.Count
Range("C1:G" & RowCount).Select

Randy Davis
Denver, CO