Slow Macro Modify

[johncena]

dear friends below two macro i want to run one time.for that i have used " call " function.this macro work fine but very slow.pls any body can combined this two macros & remake to work fast.thanks.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[royUK]

This looks the same as your previous post

[johncena]

dear sir royUK.pls check my previous post.these macros not same..
http://www.excelforum.com/excel-prog...very-slow.html

[royUK]

So why not apply what you learned from the previous post?

[Marcol]

Try this first

Please Login or Register  to view this content.

If this does what you want, we can then address Lotremove.

P.S. This is very similar to the last stages of your previous post on the subject.

http://www.excelforum.com/excel-prog...very-slow.html

The main difference is the use of AutoFilter

Cheers

[johncena]

sir Marcol it's not working.if column "E" has any values then same row column "H" value should clear.but column "E" don't have any value then column "H" values no need to clear.this macro cleaning column "H" all values.

[Marcol]

Try changing this line

Please Login or Register  to view this content.

To

Please Login or Register  to view this content.

Is that what you want?

[johncena]

thanks a lot sir Marcol now it's work very well very fast.this is last answer or u will do something to second macro also..

[Marcol]

Re: Sub Lotremove()

1/. Are you just wanting to clear all formulae in Column "M" and replace with their values?

2/. What are you trying to do with Columns "E" & "H" ?
Seems to me that they were dealt with in Sub Sticker(), No?

[johncena]

Re: Sub Lotremove()

1/. Are you just wanting to clear all formulae in Column "M" and replace with their values?

2/. What are you trying to do with Columns "E" & "H" ?
Seems to me that they were dealt with in Sub Sticker(), No?

column "M" i want to keep only first 6 characters.
Columns "E" & "H" all empty cells should fill with " ' " apostrophe.

[Marcol]

Just what this has to do with keeping the first 6 characters in a cell, I don't know?

Please Login or Register  to view this content.

However try this

Please Login or Register  to view this content.

1/. What purpose does filling blank cells with an apostrophe serve? I'm curious.

2/. There is nothing in this code, as can clearly be seen, that could not been done without a macro,

3/. For one-offs you should consider using Excel as it comes straight out of the box.


Hope this helps.

[johncena]

thanks u very much sir Marcol.now this macro work very fast.thanks a lot.i have try to give REP+ but it's saying (You must spread some Reputation around before giving it to Marcol again).sorry for that.