Find and replace macro for quick process
Hi Friends,
i need quick find replace of numbers by macro as below rules for "E" Column.
If 76 replace with 3"
115 replace with 4½"
150 replace with 6"
230 =9"
300=12"
380=15"
450=12"
457=12"
530=21"
600=24"
610=24"
760=30"
please arrange macro for quick find and replace operations.
Here, try this for any size in mm:
Formula:
Please Login or Register to view this content.
Note: Function will return two values. If you have only one value (like 230) then it will return 9" x 9" no matter only one size defined, without x.
If you have such case let me know to adopt it.
Last edited by zbor; 11-25-2016 at 04:00 AM.
Hi Friend,
thank you for your great help. i need for 450 is 18". but printed as 17 1/2". so please modify as custom definition like if found 450 then replace with 18" so individual definitions are required for find and replacing texts. and please convert as run macro function instead of function, for "C" column data. because my data is variable range in "C" column. please make it from 3" to 9". remaining definitions i will try.
Thank you.
Last edited by structo; 11-25-2016 at 05:19 AM.
I would reply - but I have a question...
I have questions however based on the link above its probably best just to solve it without any queries....
Please Login or Register to view this content.
If someone has helped you then please add to their Reputation
hi friend, thank you for your contribution. how to use your macro? i have created new module. but no macro is visible to run macro.Originally Posted by pjwhitfield
Thanking you.
How to run Post#5 code?
Thank you all.
Like this.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Hi friend,
well explanation. this function was developed at "G" column. but i need replace at existing column "E". please tweak code as Run Macro button.
Thanking you.
Try attachment (click Arrow). I left Function as is for all the work pj put in.
Hi friend,
its working. thank you for contribution.
Thank you all.
hi friend,
i got debug error due to some differences were occurred in my raw file.i need add on code to existing code for removing of merging and deleting of blank rows for consolidation of data. so please add.
Thank you very much.
Last edited by structo; 12-03-2016 at 10:38 AM.
Give this a try
Please Login or Register to view this content.
Thanks,
Mike
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
Hi MIke friend,
thank you for response. where i add your new modification to my old code?
thank you.
In your main macro
Please Login or Register to view this content.
In your main macro
Please Login or Register to view this content.
yes friend now its converting well. but not happening un merging and not removed blank rows. please tweak as final code.
Thank you very much
Maybe this
Please Login or Register to view this content.
Thank you Mike. now every thing is alright.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks