Insert formulas in VBA code

saurabhlotankar · #1 06-11-2015, 03:32 AM

Hi Guys,

NoSparks, I tried your code it works perfectly fine. But i have 80000 rows in my data so it takes lot of time to complete the task.

excelledsoftware, I tried your code but could not write it properly. If you could provide me the worksheet function code then that will be great coz it will save lot of time.

Thnaks guys.

excelledsoftware · #2 06-11-2015, 11:04 AM

Quote:

Originally Posted by saurabhlotankar

Hi Guys,

NoSparks, I tried your code it works perfectly fine. But i have 80000 rows in my data so it takes lot of time to complete the task.

excelledsoftware, I tried your code but could not write it properly. If you could provide me the worksheet function code then that will be great coz it will save lot of time.

Thnaks guys.

Yes I will have this complete for you later tonight. Please keep in mind that 80000 rows will still take a little bit of time but it shouldn't be bad After it is done. We may want to consider additional options if you find it still takes too long. I will write it up for you later tonight

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VBA code for Microsoft Word macro — select text and insert footnote	ndnd	Word VBA	10	01-06-2015 01:47 PM
Help with IF or ELSE Formulas	tsaladyga	Excel	4	07-23-2014 09:04 AM
Search and replace/insert HTML code into Master File using tags	dave8555	Excel	2	02-23-2014 03:51 PM
Need help with formulas please	paul_pearson	Excel	0	03-20-2013 06:51 AM
IF Formulas	mizzamzz	Excel	1	07-08-2010 02:32 AM