Thread: iterate columns to select certain cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Yngve Yngve is offline
external usenet poster
  
Posts: 67
Default iterate columns to select certain cells
Hei Dale

Range("A2:A" &
ActiveSheet.Cells.SpecialCells(xlCellTypeLastCell) .Row).Select
Range("B2:B" &
ActiveSheet.Cells.SpecialCells(xlCellTypeLastCell) .Row).Select
Range("c2:c" &
ActiveSheet.Cells.SpecialCells(xlCellTypeLastCell) .Row).Select

regards Yngve

Reply With QuoteReply With Quote