Microsoft Office Forums - View Single Post - [Solved] creating a named row for dynamic addressing

Thread: [Solved] creating a named row for dynamic addressing

View Single Post

Old

07-05-2018, 06:39 PM

trevorc

trevorc is offline

trevorc uses Windows 7 32bit

Windows 7 32bit trevorc uses Office 2013

trevorc uses Office 2013

Office 2013

Competent Performer

The original poster

Join Date: Jan 2017

Posts: 173

trevorc will become famous soon enough

trevorc will become famous soon enough

Default

Thanks for your help.
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.

Code:

        Set tblColumns = ActiveCell.ListObject.ListColumns
        Set ACRow = ActiveCell.EntireRow

Reply With Quote