View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Reitanos Reitanos is offline
external usenet poster
 
Posts: 123
Default Extend Selection Question

I know that I can extend the selection by address using
Activecell.Offset.Range("A1:B10").Select
but if I'm using a variable for the width is there a way to reference
that without having to calculate the column address (ie if I need to
select 28 columns starting in B)?

Thanks