View Single Post
 
Old 07-06-2018, 02:43 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2016
Expert
 
Join Date: Apr 2014
Posts: 948
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

Quote:
Originally Posted by trevorc View Post
Is it also possible to put these 2 lines of code globally/public so I don't have to repeat them in all Sub's.
Sure but if you've got multiple tables you'll need to update tblcolmns anyway, and if the active cell is likely to move row, which by definition it is, your going to have to update that too.
Reply With Quote