arri

I'm trying to pull a huge column of data into an array (500,000 rows), then remove some items that are direct duplicates of previous item, and then basically output it into a new column.... I have been going around in circles for hours now trying to do this and am not getting anywhere.. I...

workbook "invoice" column A has item numbers. workbook "price" column A has item numbers and column H price (should have price) if H does contain the price then place that info in H "invoice" ... then continuing the fill-in process until last row if the H doesn't contain a price, continue same...

I copied most of the code below from somewhere and modified it a little and it basically works how i wanted except for some conditions that I wanted to add :( The original code with slight amendment and which works is below: Option ExplicitSub INDO() Dim arr As Variant Dim wsO As...

Hi, I have looped through certain range of cells to put value in an array. Now I want to put these values inside a Textbox with multiple lines or in a Label Caption. I searched like crazy on Google but I find nothing. Can anyone help please I need to finish a project and I am stuck...

Hey folks! Happy New Year! I'm working on a sub that will loop thru folders/subfolders, open each file, and list the sheets in each file. However, I'm running into issues for files that are .xlsm or are password protected. Rather than click each time one of these files come's up, I'd like to...