LinkBack URL
About LinkBacks
How can i modifid in this code
Please Login or Register to view this content.
How can i modifid in this code
Please Login or Register to view this content.
Hi,
I think you need to tell us a bit more.
What do you want to modify and what do you want to achieve for starters. Probably best if you upload the workbook and manually add some calculated results that you expect to see AFTER the macro has run. Be sure to tell us which are the results cells and in a narrative form how you arrived at the results.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
i am trying to run macro(deci) but it is not showing anything
i see in my sheet having fractional values in one row but in few rows haveing only string of character(Sheet3)
How can i modify this
Please Help me out
Please Login or Register to view this content.
Please explain in a narrative with reference to your sheet data what you are trying to achieve. I find your macro difficult to follow and not knowing what it's meant to achieve doesn't help.
Add some manual results and explain where the results are and how you have achieved them.
Using that code for converting fraction to decimal in whole for respective column(attribute values)
i that column i have fraction values it is converting but what it is happening that in that column i have some rows haiving only string of characters but not having any fraction values
what i was trying to do that if run macro it should only convert only fraction values leaving other rows which is having only string of characters
Please can you give some specific examples as requested earlier.
And to be clear we need to know what cells you are referring to and what the result should be (and where it should be) after whatever needs to be done has been done.
Show an example for each of any permutations/lengths of data you may have.
When i am trying to run macro it is not showing any output Please help me out
example(1):
attribute value1
15/16 IN LG, 1-1/16 IN OD, 11/32 IN THK,21/128 IN ID
19/128 IN LG, 2-3/64 IN OD, 1/2 IN THK, 5/64 IN ID
dfgsfgmkldfsg
19/128 IN LG, 2-3/64 IN OD, 1/2 IN THK, 5/64 IN ID
height
19/128 IN LG, 2-3/64 IN OD, 1/2 IN THK, 5/64 IN ID
19/128 IN LG, 2-3/64 IN OD, 1/2 IN THK, 5/64 IN ID
19/128 IN LG, 2-3/64 IN OD, 1/2 IN THK, 5/64 IN ID
Last edited by baig123; 07-10-2014 at 01:54 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks