sourcerange

Hi I am using below formula to unprotect, autofill and protect sheet in excel however it is giving error message. Sub sbUnProtectSheet() ActiveSheet.Unprotect "9999" Set SourceRange = ActiveSheet.Range("B10:H10") Set FillRange = ActiveSheet.Range("B11:H39")...

I'm new to using VBA, but I found the code shown below on the internet which allows you to select specific files that you choose and copy the data into a new file which is used as a summary. Firstly, I need to amend the code so that rather than create a new file it pastes the data into a sheet...

Good afternoon and Happy Friday! I found and modified a macro many, many moons ago that takes the data from the first row and certain columns of a group of excel workbooks and creates one excel file with all of the data. It works FABULOUS however I do not really know how it works. I now need to...

Hello, I'm a mid-level VBA user and so I've searched and modified the following code to loop through 5 files, each with a "Master" tab. It's worked for months now, but threw an overflow error today on the highlighted piece of code. It's odd because it's crashing between rows 82729 and 132711...

Hi, I'm trying to complete a macro which I've borrowed from another forum, essentially I'm trying to copy merge data from a number of different workbooks (The first sheet only) all contained within the same folder. I was the Macro to copy all rows which contain data from A2 down to V2000. I...

I have worksheets that added to a folder daily, and I would like to run the following code every day to add the sheet's data to the master worksheet's data. My problem is that instead of adding to the existing data on the worksheet titled "MuniReg" it overwrites the data, I believe I have...

Hello, I am trying to copy specific rows from multiple workbooks into a summary spreadsheet. Thus far, I've been able to figure out how to merge specific rows from all workbooks into the summary file, but cannot seem to figure out how to merge multiple rows (non-consecutive) into the summary...

Hi All My code works if I have more than 3 rows in current region. When I have 2 rows the source range and end range are the same IE a cell at activecell offset 1,5 Therefore the fillrange doesn't make sense. How do I get this code to "copy and paste" in the same cell? Spreadsheet example ...