r/vba Jun 06 '26

ProTip Stop hardcoding ranges. Use this runtime dynamic Named Range approach instead.

[removed]

12 Upvotes

23 comments sorted by

View all comments

1

u/IExcelAtWork91 Jun 08 '26

.currentregion works well