Calculate Range area of Sheet1 and use it in a macro

The macro I have created copies the rows and columns in Sheet1 to Sheet3. However, my selection range varies. Sometimes the area is Range("A1:D94").Select . Sometimes the area is Range("A1:D125").Select . I need to calculate the CalculateRowMajorOrder and replace the Range("A5:G94").Select with Range(strRange).Select. I have tried declaring strRange as a String and as an Object. It always blows up at the 'strRange= CalculateRowMajorOrder line.
Am I using the method wrong?

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Sheet1 is a spreadsheet created in Excel of items that were returned to our company. It has 4 columns: Item Id, price, quantity returned, and Price times Quantity. Sheet2 is a connection to the database that supplies all the results of a Query that provides the Item Id and the location where the item should be returned to inventory. Sheet3 has a copy of everything in Sheet1, but starting in column B instead of column A. Column A uses VLOOKUP to provide the Location from Sheet2.

Sometimes there are 20 items (or rows) in Sheet1. Sometimes there are 94, sometimes 55. my Range is Sheet1.(A1:D20).select or Sheet1.(A1:D94).select or Sheet1.(A1:D55).select respectively to the previous statement.

I need to calculate the number of rows in my macro, so it doesn't miss any items and doesn't add any rows where there are no items. I thought the Range method would calculate that for me, but it isn't working.

Featured Post

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Introduction
This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm),
I will briefly cover:
1) An overvie…

Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…

The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability.
Flipping Coins in Excel: Enter =RAND() into cell A2:
Recalculate the random variable…