Dynamic Ranges - Create Using VBA as looping through Sheets

Hello,

I’m attempting to grasp the concepts of working with arrays.

• Is it possible to loop through a series of worksheets containing the same types of data
• Select all the data on each sheet
• Declare the data as a range dynamically ( if this is necessary)
• Load that range into an array (nRows, 5Col)
• And then perform actions based upon items in that array?

Please Login or Register  to view this content.

I’ve attached a workbook with sample data and the code that I’ve managed to cobble together at this point.
It doesn't loop through the worksheets nor dynamically create the data ranges.

Thanks for your assistance.
Mark

I wrote the attached code for another thread. It gives you some direction. I have put comment on each line. No every single line may be relevant to your case, it is just a guide.

Thanks a lot AB.
It's an elegant piece of code.

I had a problem with a "Subscript out of range" on this line.
I commented out that particular "If" statement and the code ran fine.

Please Login or Register  to view this content.

I was wondering what the intention was for this bit of code?
When I changed the number from 7 to 5, I received the value of the date in column five.
The problem was, it wouldn't output at all to the Master Worksheet.

I'd be interested in understanding the mechanics of this.

Thanks again.

Please Login or Register  to view this content.

Simply testing if column G is nil. It is one of the condition for that particular task.

The reason forgetting the error is this line.

Please Login or Register  to view this content.

The max column loop the X array can take is 5, which is E. If you change it to G, you would not get an error.

I was wondering what the intention was for this bit of code?

The person who asked the question wants to copy all columns if column E is blank. So, the condition is "If statement". Not all rows in column E are blank.

Thanks for the explanation.
I didn't think to look back in the code to find the problem.
A very useful bit of information.

Thanks again.