Thread: Is there a macro i can use to copy a cell +1
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default Is there a macro i can use to copy a cell +1
Maybe...

=LEFT(F19,2)&TEXT(RIGHT(F19,2)+1,"00")



Bill M. wrote:

I am wondering if there is a VBA code to copy a whole cell into another whole
cell and add 1 more number to it. E.G. one cell E19 is 9N08, and i was trying
to put 9N09 into cell F19, E21 is 9S18, and i was trying to copy 9S19 into
F21 etc. for the whole worksheet.

--

Dave Peterson
Reply With QuoteReply With Quote