Hi,

In col. A I have text and numbers. and in col. B,C,D,E,F I have numbers. I'm
looking for a macro that looks in Col.A and find texts and move row A,B,C,D,E,
F One to the right.

thx,


ex.

A B C D E F G
Tom 28 6 8 46 36
896 56 3 2 7 10



Result.

A B C D E F G
Tom 28 6 8 46 36
896 56 3 2 7 10

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200709/1

Hi,

Really no need for a macro -
1. Select the data in column A
2. Press F5, Special
3. Turn on the Constants option and uncheck Numbers, Logicals, and Errors
then click OK
4. Press Ctrl+Shift++ (plus sign) and choose Shift Cells to Right.

If you need it in a macro, you can record it.

--
Cheers,
Shane Devenshire


"saman110 via OfficeKB.com" wrote:

Hi,

In col. A I have text and numbers. and in col. B,C,D,E,F I have numbers. I'm
looking for a macro that looks in Col.A and find texts and move row A,B,C,D,E,
F One to the right.

thx,


ex.

A B C D E F G
Tom 28 6 8 46 36
896 56 3 2 7 10



Result.

A B C D E F G
Tom 28 6 8 46 36
896 56 3 2 7 10

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200709/1

It worked great.

Thank you.


ShaneDevenshire wrote:
Hi,

Really no need for a macro -
1. Select the data in column A
2. Press F5, Special
3. Turn on the Constants option and uncheck Numbers, Logicals, and Errors
then click OK
4. Press Ctrl+Shift++ (plus sign) and choose Shift Cells to Right.

If you need it in a macro, you can record it.

Hi,

[quoted text clipped - 15 lines]
Tom 28 6 8 46 36
896 56 3 2 7 10

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200709/1