troubleshooting Question

DEFINE RANGE IN AN EXCEL 2013 MACRO

Avatar of radrick60
radrick60 asked on
Microsoft ExcelVB Script
41 Comments1 Solution600 ViewsLast Modified:
AS AN EXAMPLE, USE THE COLUMN LISTED BELOW
          A
 15    10
 16      5
 17     -50
 18      8
 19      10

Trying to record a macro to obtain an average of the column. the cursor would be located at cell a20.

The range above is  a15:a19

The macro must be adaptable because the next sheet would have a different range
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 41 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 41 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros