Thread
:
How to write macro
View Single Post
11-19-2017, 11:43 PM
ArviLaanemets
Windows 8
Office 2016
Expert
Join Date: May 2017
Posts: 932
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)
ArviLaanemets
View Public Profile
Find all posts by ArviLaanemets