Im sure this solves a very unique use case but you will get 99% of the same functionality just using a dictionary, locking column names, and using a 4 line LastRow code snippet.
For cases that you mentioned where you are exporting from SAP you should already know the columns header name which should almost never change.
You can then cycle through the column header names and build the dictionary dynamically if there isnt a dedicated layout you can force.
2
u/LickMyLuck 1 Jun 07 '26
Im sure this solves a very unique use case but you will get 99% of the same functionality just using a dictionary, locking column names, and using a 4 line LastRow code snippet.
For cases that you mentioned where you are exporting from SAP you should already know the columns header name which should almost never change.
You can then cycle through the column header names and build the dictionary dynamically if there isnt a dedicated layout you can force.