cellsc

Hello all, I need some help to improve my code. Right now I only have about 1700 lines to go through and the loop i created takes 5-10min. I must be doing something wrong or is there a way to speed up this code? Code searches one column per cell for specific word (2 options) then updates...

Hi Guys and Girls. I just have a quick question. My VBA knowledge is ok, however I am not very good at programming with SQL. I have a piece of code which works fine. It is just that it is not robust, I have created a loop with an string and open an recordset at the end of my loop I close...

Hi I'am trying to do this. Have a spreedsheet that have some columns like this the table under here <tbody> <tbody> A B C D E F G H I J K 1 Name Date Finished Name Date Finished Name Date Finished 2 Roy 23.4.2018 x Mette 27.05.2018 Hanne 01.12.2018 3 Mette 27.5.2018 Oskar...

Hi All, I am adapting a code I found on the web into my macro, it works exactly as I would like except for one aspect. I modified the loop to spit out sSentence into column C, however, I am unable to figure out how to make sSentence be placed in the correct row. As of now the data is being...