Charting variable ranges

		Microsoft Office Forums > Microsoft Excel > Excel
Charting variable ranges

FAQ

Thread Tools

Display Modes

09-21-2017, 12:26 AM

Pecoflyer

Windows 7 64bit Charting variable ranges

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,948

Pecoflyer has a reputation beyond repute

Quote:

Originally Posted by mreynolds1775

Code:

=INDEX('Sales'!$M198:$HR198,MATCH(9.99E+307,'Sales'!$M198:$HR198)-30):INDEX('Sales'!$M198:$HR198,MATCH(9.99E+307,'Sales'!$M198:$HR198))

returns a #Value.... any assumptions?

Returning an error as named range?

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
I want to create a bar chart of multiple variable. Then I need to draw trend lin of those variable	shimulsiddiquee	Excel	1	05-16-2017 07:39 AM
Take String of numbers, expand ranges, sort, then compress back into ranges	AustinBrister	Word VBA	19	08-22-2016 05:18 PM
Run Time Error '91': Object variable or With block variable not set using Catalogue Mailmerge	Berryblue	Mail Merge	1	11-13-2014 05:36 PM
Run-time error 91 object variable or with block variable not set	JUST ME	Word VBA	4	03-25-2014 06:56 AM
Run-time error '91': Object variable or With block variable not set	tinfanide	Excel Programming	2	06-10-2012 10:17 AM