I only re-wrote what you already had so that vba would recognize the variables
You made up the formula
When I create the dynamic range manually the Refers to formula is
=Sheet1!$A$2:INDEX(Sheet1!$A:$A,COUNTA(Sheet1!$A:$ A))
(There is no space before the last A the forum software is inserting it)
Last edited by NoSparks; 01-25-2022 at 10:08 AM.
Reason: added manually created info
|