LinkBack URL
About LinkBacks
dear friends i don't have VB knowledge.i have found two macro from net & i have make above macro.it's work but it's take too much time.pls any body can remake this macro to run fast.thanks.
Please Login or Register to view this content.
macro work but very slow
dear friends i don't have VB knowledge.i have found two macro from net & i have make above macro.it's work but it's take too much time.pls any body can remake this macro to run fast.thanks.Please Login or Register to view this content.
Last edited by johncena; 04-04-2010 at 11:48 AM.
The Slow part is
Do you have to loop through all 1192 cells in this range?Please Login or Register to view this content.
dear Marcol my data range is not fix.some time it's 5 rows,some time it's 100 rows.pls u can make this to run in used data range.pls help me.
Move your LR resolution up to the top and then use it in the first FOR/EACH like you did for the second. That should help some.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
sir JBeaucaire thanks for your reply.i am downloading data from my system to excel.after that i have tp copy that data to my worksheet.on that data i have try to run my macro & it's not work.then my friend told me with that data has some extra space before running the macro i should remove that space.for that i try above macro first part & it's work..
second part u can understand i want to add each values in column "J " to equal " = "
that last part i have take from macro record & i want to remove column "E" all " - ",column "D to H" all space also i want to remove.
i think now u have some idea about my macro...
maybe to use
Please Login or Register to view this content.
Люди, питающие благие намерения, как раз и становятся чудовищами.
Regards, ?Born in USSR?
Vusal M Dadashev
Baku, Azerbaijan
Or ... when using ws functions
.Please Login or Register to view this content.
This will give you a much better performance.
Looking for great solutions but hate waiting?
Seach this Forum through Google
www.Google.com (e.g. +multiple +IF site:excelforum.com/excel-general/ )
www.Google.com (e.g. +fill +combobox site:excelforum.com/excel-programming/ )
Ave,
Ricardo
thanks u very much for your all helps.pls any body can give me the complete macro code.thanks.
In response to your PM
Try this, it uses rwgrietvelds' suggestion and a bit of guess work
Please Login or Register to view this content.
A sample workbook would help to clear up any guesswork.
Cheers
Re: macro work but very slow
thanks sir Marcol.it's almost work.some cells has data like this.'12/2.i have used " ' " (apostrophe) before typing 12/2 because other wise it's automatically change to date format like this." 2-Dec ".after running this macro.that my apostrophe disappear & it's again change to " 2-Dec ".
this part i want to run only in column "D" to "G" range only.i don't want to run whole sheet..
Please Login or Register to view this content.
Last edited by johncena; 04-04-2010 at 10:41 AM.
Try this
If this doesn't workPlease Login or Register to view this content.
A sample workbook would help to clear up any guesswork
Cheers
EDIT:
Missing lines
Sorry for that.Please Login or Register to view this content.
Better if each section is written as a function.
Last edited by Marcol; 04-05-2010 at 04:28 AM. Reason: Missed 2No. lines in code
thanks u very much sir Marcol.it's work very well.thanks a lot again.REP+
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks