Thread: incrementing a cell value
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jay Fincannon Jay Fincannon is offline
external usenet poster
  
Posts: 23
Default incrementing a cell value
how can i shorten this?

ActiveCell.Offset(0, 1 - ActiveCell.Column) = ActiveCell.Offset(0, 1
ActiveCell.Column) +1
Reply With QuoteReply With Quote