Thread: In excel can I display a cell based on a calculation (eg M(14/2)?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
RB Smissaert RB Smissaert is offline
external usenet poster
  
Posts: 2,452
Default In excel can I display a cell based on a calculation (eg M(14/2)?
Not sure what exactly you are trying to do, but you can do:

Dim r as long

r = 14\2
Cells(r, 3).Select


RBS


"rnrxtreme" wrote in message
...


Reply With QuoteReply With Quote