Thread: macro for selecting non-adjacent cells
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default macro for selecting non-adjacent cells
Use this for the row where the activecell is

Cells(ActiveCell.Row, 1).Range("A1,C1,E1,H1,K1").Select



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"EricBB" wrote in message ...
how can i edit the below line so that row no. will be a variable. i.e. if i
select cell "A5" the "3" will become 5.

Range("A3,C3,E3,H3,K3").Select

thanks for any help.
Reply With QuoteReply With Quote