Replace a formula with it's value

[Jeferson11]

Hello,
Anybody could help me to solve a similar issue [to this thread]:
Everytime that I type "x" on column "A", the range from "B" till "N" change the formula by its value.
Thanks

[Cheeky Charlie]

Change the formula by its value
Do you mean - the formulae in B:N for the given row are replaced with their values?

This does that:

Please Login or Register  to view this content.

[Jeferson11]

Hello ! Thanks a lot ! Perfect !
Following the rules from this community I was advised to open a new post with my issue. Follow the link below. (however I consider the issue solved)

http://www.excelforum.com/excel-prog...46#post3124646

[Jeferson11]

Hello ! Thanks a lot ! Perfect !
Following the rules from this community I was advised to open a new post with my issue. Follow the link below. (however I consider the issue solved)

http://www.excelforum.com/excel-prog...46#post3124646

[Cheeky Charlie]

From PM:

After I type "x" at column "A" and click "enter" the macro runs and the entire range from "B" till "N" remains selected. How can I do to back it to "A" (at the same row) ? Thanks

Good point, that was lazy of me...

Please Login or Register  to view this content.