Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select current region less 2 rows at the top
I would like to select my current region, less 2 rows at the top. My current
region is A1 to S?, I would like vba to select A3 to S?. I'm thinking maybe a rezsize or an offset but I can't figure out the code. Thank you. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select current region less 2 rows at the top
Try code like
Dim R As Range With ActiveCell.CurrentRegion Set R = Range(.Cells(3, 1), .Cells(.Cells.Count)) End With R.Select Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Sat, 16 May 2009 12:43:41 -0500, "John" wrote: I would like to select my current region, less 2 rows at the top. My current region is A1 to S?, I would like vba to select A3 to S?. I'm thinking maybe a rezsize or an offset but I can't figure out the code. Thank you. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select current region less 2 rows at the top
'Caution - air code...
Set CR = ActiveCell.CurrentRegion Set CR = CR.Offset(2, 0).Resize(CR.Rows.Count -2, CR.Columns.Count) -- Jim Cone Portland, Oregon USA "John" wrote in message ... I would like to select my current region, less 2 rows at the top. My current region is A1 to S?, I would like vba to select A3 to S?. I'm thinking maybe a rezsize or an offset but I can't figure out the code. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Select the current region excluding the top row | Excel Programming | |||
looping through current region | Excel Programming | |||
Select current region and print | Excel Programming | |||
Selecting a range composed of current region + 2 rows | Excel Programming | |||
Select current region less one column | Excel Programming |