creating a named row for dynamic addressing

		Microsoft Office Forums > Microsoft Excel > Excel Programming
creating a named row for dynamic addressing

07-05-2018, 06:39 PM

trevorc

Windows 7 32bit creating a named row for dynamic addressing

Office 2013

Competent Performer

Join Date: Jan 2017

Posts: 173

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Creating Dynamic Ranking Tables	ssol2016	Excel	1	10-27-2016 08:47 AM
creating a code to create dynamic text in word	ah8471	Word VBA	1	12-29-2015 10:52 PM
Creating a dynamic summary sheet	FenelonPaul	Excel	5	09-23-2015 07:11 AM
Help Creating A Dynamic Footer	Mikemo	Word	3	02-05-2013 11:58 AM
Dynamic Named Ranges using text	hannu	Excel	0	06-22-2010 04:42 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:53 AM.