|
|
|
|
#1
11-19-2017, 11:43 PM
|
|||
|
|||
You can define a dynamic named range (Formulas > Name Manager) for table on sheet HJM_Sakila_Backup, and use it in any calculations.
Code:
nDataRange =OFFSET(HJM_Sakila_Backup!$A$1,1,,COUNTA(HJM_Sakila_Backup!$A:$A)-1,6) 
|
|
| Tags |
| excel macros 2013, macro |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Write a macro to change formulas
|
Xyz_999 | Excel | 2 | 04-20-2016 10:40 PM |
|
Write a macro to change formulas
|
Xyz_999 | Excel | 1 | 04-20-2016 09:51 PM |
| write need help and copy write need help on another page auto | wykoems | Word | 2 | 07-25-2013 07:56 AM |
| How do you write a macro with an IF Function | Scheuerman1987 | Excel | 5 | 06-05-2013 06:04 AM |
|
How to write a macro to find a specified name in a list of data?
|
Jaffa | Excel | 1 | 10-23-2010 02:39 PM |
Windows 8 
Office 2016
Hybrid Mode