Running VBA in excel is too slow, how to make it faster?

**rsbuslon** · 03-14-2013, 03:38 AM

Hi I'm not an expert in VBA and is just trying to 'crawl' my way in finishing a project. I have a code for my command button (Button_Submit) and the code is below. The results are too slow before it come up. Can I make it faster? Please help.

Please Login or Register  to view this content.

**OllieB** · 03-14-2013, 03:58 AM

Replace all occurrences of

Please Login or Register  to view this content.

by

Please Login or Register  to view this content.

at the beginning of your routine you execute the following code without any purpose that I can identify - i.e. can be removed

Please Login or Register  to view this content.

**rsbuslon** · 03-14-2013, 05:18 AM

at the beginning of your routine you execute the following code without any purpose that I can identify - i.e. can be removed

i have two sheets that corresponds to the submit button, namely INFLOWS_WC and INFLOWS_PERSONAL, so basically i have records to input and the conditions above would determine to which sheet the records will be added.

iRow = ws.Cells(ws.Rows.Count,"A").End(xlup).Row+1

However, i tried this, and it made the execution so fast! This is what I need. Thanks for the help!

**OllieB** · 03-14-2013, 05:55 AM

Originally Posted by rsbuslon

i have two sheets that corresponds to the submit button, namely INFLOWS_WC and INFLOWS_PERSONAL, so basically i have records to input and the conditions above would determine to which sheet the records will be added.

I know, but within the Select case statement you again execute the code to determine the first available row, so the first one at the top of the routine does not seem to be needed