Thread: incrementing a cell value
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett Don Guillett is offline
external usenet poster
  
Posts: 10,124
Default incrementing a cell value
What are you trying to do?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jay Fincannon" wrote in message
...
how can i shorten this?

ActiveCell.Offset(0, 1 - ActiveCell.Column) = ActiveCell.Offset(0, 1
ActiveCell.Column) +1

Reply With QuoteReply With Quote