Thread: How to write macro
View Single Post
 
Old 11-19-2017, 11:43 PM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default
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)
Reply With Quote