Thread: Select a range in a column in currentregion
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
ward376 ward376 is offline
external usenet poster
  
Posts: 360
Default Select a range in a column in currentregion
Brainfart gone

Cells(1, 1).CurrentRegion.Offset(1, 0).Columns(1).FormulaR1C1 =
"=RIGHT(RC[2],3)&RC[3]"

Reply With QuoteReply With Quote