Help Excel Macro to move rows

Closed
Noelski - Sep 3, 2009 at 02:20 PM
 Noelski - Sep 3, 2009 at 02:47 PM
Hello Everyone,

May i ask your assistance in a macro to move the cell to the right if the contents are not numbers.

i currently have a data list but column C, D and E are not aligned, if there was a macro that would move it would do the trick.

Kind regards,

Noelski
Related:

2 responses

Blocked Profile
Sep 3, 2009 at 02:30 PM
Hye Noelski,, Normally this is automatically done if you have set the cell format to general, text are aligned to left and number to the right ...

did i miss something?
0
Hi,

Apoligies if i've been vague.

Columns A and B with data that never change, but on Column C, D and E are not.

Ex
A B C D E F
Name Address USD 100 Paid
Name Address USD 250 Pending


If i can move the data on column C to the right it will do the trick.
0