Making Macro Run Faster

[nalgene5622]

I have a macro and I am starting to learn how to write macros. I was wondering if anyone had any suggestions as to how to make the macro run faster. Any tips would greatly be appreicated. Thanks.

Calling the macro when cell is changed

Please Login or Register  to view this content.

The macro itself

Please Login or Register  to view this content.

[Mordred]

Hi nalgene5622, are you able to supply us with the workbook? If yes, it should be a sanitized version with no personal information in it. It would benefit all those who try to help if they had the data types to work with.

[mardyl]

Hi, try adding a string on the very beginning of the macro, after "sub" string
"Application. ScreenUpdating= False"
You won't see on the screen how macro works, but it will work faster

regards

[nalgene5622]

I have attached workbook Mordred. Sorry about that next I will attach it with the original post. Thanks for the request mardyl I will try that. Anything else come to mind?

[Mordred]

I'm not really getting what it is you attempting by your example but your code seems to run fairly quick. What exactly is your issue?

[nalgene5622]

Mordred,

I have several macros that will run when a cell within a row has a value. The macros to do this are very similar to the one I posted. I just was not sure if there was something to make the code run faster.