View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Adam1 Chicago Adam1 Chicago is offline
external usenet poster
 
Posts: 9
Default Range selection with R1C1

I would like to replicate Range("D8:F8","I8:K8").Select using R1C1 references.

Can I somehow make the Range(Cells(r,c),Cells(r,c)).Select work for a
compound range?

Thanks