Thread: Select current region less 2 rows at the top
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone[_2_] Jim Cone[_2_] is offline
external usenet poster
  
Posts: 1,549
Default 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 With QuoteReply With Quote