Copy and Paste calculated range to another worksheet

[jmcartwright_fl]

I need to copy and paste range A4:H# (the row # to include is calculated in a formula called "PRINT END"). For example, Range("PRINT END") = 17 so I need to copy and paste "A4:H17" to another worksheet called "PRINT". I cannot use End.(xlup) calculation for this.

[stnkynts]

Its not clear how things are exactly. This might work for you:

Please Login or Register  to view this content.

[stanleydgromjr]

jmcartwright_fl,

Welcome to the Excel Forum.

Your rangename can not contain a space character.

You did not give us the worksheet name of where the rangename, and/or, raw data are in.

And, you did not give us where in worksheet PRINT the data would be copied to.

The below line of code works in my test environment.


Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).

Please Login or Register  to view this content.

You may also want to consider having the macro first check if there is a valid number in the rangename.

[stanleydgromjr]

jmcartwright_fl,

You marked your thread SOLVED, without any feedback, or, comment(s)?

You are very welcome. Glad we could help.

And, come back anytime.