I'm trying to create a named range that can be resized based on the number of rows, but I'm getting an invalid use of property error, and I don't understand why. I'm trying to follow the VBA code in this post, and I don't know what I'm doing wrong.
Dynamic range in VBA with Excel functions
Hi, I'm trying to set the sourceRange as a dynamic range in VBA that starts from cell AC22 and offset with the height of COUNTA(data_date_range)+1, where data_date_range is a named range. and width of Columns(InputClaims), where InputClaims is also a named range. The following formula works...
www.mrexcel.com