createdCOMMANDBUTTON in a worksheet3 can i convert fraction values to decimal whle sheet

[baig123]

Attachment 327264I have created COMMAND BUTTON in a WORKSHEET 3 For convert fraction to decimal values for whole WorkSheet i have some 14 columns having fraction values

I have used this code in Command Button for converting the wholesheet

Please Login or Register  to view this content.

i trie modiefied it this error ------------>

see i have attached my sheet

[davesexcel]

Can you edit your post and add code tags to the code?

There is no sheet attached.

[Miroslav R.]

Hi there,
modify the error line:

Please Login or Register  to view this content.

(for the col A)

[baig123]

now i am getting Type mismatch error 13

[baig123]

now i am getting Type mismatch error 13 here

Please Login or Register  to view this content.

[Miroslav R.]

sorry...

try:

Please Login or Register  to view this content.

[baig123]

still i am getting Type mismatch error 13 here

Please Login or Register  to view this content.

[Miroslav R.]

there is nothing wrong with that.
Do You have 'Sheet3' in Your workbook?

[baig123]

see i have attached my Excel sheet

[Miroslav R.]

Hi,
I change 'Sheets("Sheet3")' to 'WorkSheets("Sheet3")' and it works...
but it stops on this line:

Please Login or Register  to view this content.

because Your

Please Login or Register  to view this content.

equals to zero, and therefore You have error in LEFT.

[baig123]

Thanks for your knowledge