Macro Not Solving For Fractions

Whylucky

New Member
Joined
Sep 24, 2013
Messages
39
Hey Everybody,

So i have a unique problem, I'm using a find code to extract text and separate it out to individual cells. Then a macro solves an equation based on the extracted values. The problem is when i use fractions the macro will not solve, i attached a link to share the file. Any help would be greatly appreciated.

File Location
https://www.dropbox.com/s/2mv2n6r40doyfgm/test2.xlsm?dl=0

Regards,
Whylucky
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.
Won't let me open the file. To paste your dataset, simply select the entire dataset from your excel table and Control C. Then come to this forum and Control V into the reply area.
 
Upvote 0
Macro Not Solving For Fractions

Someone answered my question on this other site, there is also me table as an attachment there, thanks for trying to help
Glad your question was resolved. However, for the future, please keep in mind #10 of the Forum Rules and provide any cross-link information at the start of your thread.

In relation to posting sample data, a simple copy/paste does not work for all browser & system versions so also note the suggestions in my signature block below.
 
Upvote 0

Forum statistics

Threads
1,214,591
Messages
6,120,427
Members
448,961
Latest member
nzskater

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top