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.

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

Hi Bill,

The fill handle will do that for you,

With 9N08 in E19
Grab the fill handle and drag it across as far as you like.

The fill handle is the little black box at the bottom right
of the active cell. When you hover your cursor over
that box it will change to a small cross, just left click and drag.

If you can't see the fill handle you may need to go to
ToolsOptionsEdit Tab and Check 'Allow cell drag and drop'

HTH
Martin

"Bill M." <Bill wrote in message
...
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.

Another thing I was wondering is if i could change the letters in the cells
from s, n, etc. to an A? after being copied?

"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.

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

If you really want a macro, you'd have to specify what that "etc" means. Or if
the formula works, you could use the formula to populate the range and then just
convert to values.

Bill M. wrote:

Another thing I was wondering is if i could change the letters in the cells
from s, n, etc. to an A? after being copied?

"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