I have searched through everything I can find and am not really getting anywhere. I have a 3 column sheet with a dynamic named range spanning column A. I have tried this
and it works to a point. The problem is that the number of rows changes. I have tried thisPlease Login or Register to view this content.
Which failed because variable LastRow was not allowed in the Array declaration.Please Login or Register to view this content.
Any ideas?
Bookmarks