I have a WorkSheet Change macro to populate some formulas when certain cells change. So far I have difficult in using the macro to enter an Array formula. I keep getting error 'Method 'Range' object WorkSheet failed. Any ideas on how I can get the macro below to enter an Array Formula when some cell changes?

Please Login or Register  to view this content.