Thank you for your help. Both of your solutions helped point be in the right direction. I was missing one critical component to the MyCount variable.
MyCount = Sheets("Sheet1").Cells(C, 3).value
the MyCount varialbe was not getting the value of cell C3 so the loop was never functional. Here is...
So it's probably obvious that I am a newbie by looking at my code. Why doesn't this work? What should I do to fix?
In this example I use the Excel Formula in C3 =CountA(Sheet2!A:A), which returns the value of 11 (number of rows not empty), which includes Headers.
I want to copy the Range on...
Here's the scenario:
I have four MS Excel workbooks, each with the same number of columns (A - F) that contain inventory information on Sheet1.
I want to copy each of these four sheets into one master list. Can anybody help with this?
