creating a named row for dynamic addressing

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

FAQ

Thread Tools

Display Modes

07-06-2018, 02:43 AM

p45cal

Windows 10 creating a named row for dynamic addressing

Office 2016

Expert

Join Date: Apr 2014

Posts: 948

Quote:

Originally Posted by trevorc

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.

« Previous Thread | Next Thread »

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:55 PM.