View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Neil Pearce Neil Pearce is offline
external usenet poster
 
Posts: 109
Default Cell Referencing

Dear all,

Is it possible to reference cells in Excel using numbers for both rows and
columns rather than the letter and number reference as is standard?

If so, is it possible to write a macro that selects range A1 to A+X:1+Y
where X & Y are variable integers in other cells?


Thanking-you in advance,

Neil