How to write macro

yoyo4 · #1 11-18-2017, 06:56 AM

HI

Can you help me write a macro????
attach macro sheet with detail.

ArviLaanemets · #2 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)

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