cellsnextrow

Hi All, I am new on this forum. I have recently developed a macro through which I am able to list all files present in the sub-folders. However, there are large number of files (in thousands) and once I run my macro, it wants me to keep my hand on enter key for nearly 5 mins. Can any one tell...

Please forgive me and any help would be greatly appreciated. I am trying to get a VBA to extract a shared calendar from outlook. The below will get my information but I am having trouble finding a way to get another calendar. I've been googling this for a while but most solutions are way over my...

So the user has a form which exports to another sheet, I need to put in columns and instead of rows Private Sub ClearButton1_Click() Call UserForm_Initialize End Sub Private Sub CloseButton2_Click() Unload Me End Sub Private Sub Export_Click() Dim emptyRow As Long 'Make Sheet3...

Hello - and thanks for any help or wisdom you may be able to pass on to me. My goals are below broken down by step. 1. User clicks button on active excel sheet (open items) that opens user form 2. User fills in info and hits 'submit' 3. Confirmation message box appears to ensure user wants to...

Greetings, below is a snippet of code from a userform that we have been using for a while. The form has a multitude of textboxes that the user enter data into, and then these textbox values get passed to a worksheet; pretty standard stuff and it works fine. They just asked me if I could change...

Greetings, I have been using this userform and code for several months without issue, but today I added a couple of textboxes to my userform to pass data to a different sheet; and now I am having issues with the new textboxes. The original code passed the userform data to one sheet -"wafer...

Hi - Im trying to list out the names of all folders and files in a folder and also get the size, name, modified etc I also am excluding any hidden files as this appears to be included in my count. Im trying to get a count of all the sub folders and count of all files also This code appears to...

Hi all - hope you are all good Im hoping you can please help me with this. I believe this code lists all the file paths, name, subfolder files, size etc within the main folder Can you please help me amend this code so that i can seperate and add the folder name? I also write another sub that...

Good evening, ive been attacking this code for ages and just cant get it to run. its not the tidiest code but it made sense to do it this way in my head. ive created a userform,which I want to transfer into 5 rows in a spreadsheet. the first few columns would all contain the same info, name...