G
Guest
I need a work around to the following situation.
I'm editing a lot of cells to split the data into two cells and there is a
pattern, but Excel is picking up 'keystrokes' I don't want. aaaa is always a
4 digit number, and bbbb is various text.
Before:
cell 1 cell 2
aaaa bbbb
Desired After:
cell 1 cell 2
aaaa bbbb
I recorded a relative macro, and I get the desired result the first time,
BUT, not the second.
Example:
Before:
cell 1 cell 2
aaaa bbbb
Desired After:
cell 1 cell 2
aaaa bbbb this one works.
next set of two cells, before:
cell 1 cell 2
cccc dddd
After Actual when macro is run:
cell 1 cell 2
aaaa bbbb
even tho' the macro is relative, Excel is obviously remembering the value's
aaaa and bbbb on subsequent cells; this I do NOT want.
Help? Thanks.
I'm editing a lot of cells to split the data into two cells and there is a
pattern, but Excel is picking up 'keystrokes' I don't want. aaaa is always a
4 digit number, and bbbb is various text.
Before:
cell 1 cell 2
aaaa bbbb
Desired After:
cell 1 cell 2
aaaa bbbb
I recorded a relative macro, and I get the desired result the first time,
BUT, not the second.
Example:
Before:
cell 1 cell 2
aaaa bbbb
Desired After:
cell 1 cell 2
aaaa bbbb this one works.
next set of two cells, before:
cell 1 cell 2
cccc dddd
After Actual when macro is run:
cell 1 cell 2
aaaa bbbb
even tho' the macro is relative, Excel is obviously remembering the value's
aaaa and bbbb on subsequent cells; this I do NOT want.
Help? Thanks.