Posted to microsoft.public.excel.programming

external usenet poster

Posts: 39

Data ranges

Thanks to all who helped with my command button post.
Another question though, still the same macro!

I'm using the LINEST function to find paramaters for
equations of lines. Unfortunately if there are blank cells
within the range, Excel returns VALUE!. Is there a way for
excel to use only the cells that have data in them in the
LINEST calculation?

Many thanks,

Nick

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Auto set data ranges	LiAD	Charts and Charting in Excel	2	January 13th 09 08:47 AM
Data Ranges	ChuckF	Excel Worksheet Functions	1	March 27th 06 11:20 PM
Data ranges within a column	JT	Excel Worksheet Functions	4	January 9th 06 09:52 PM
Data ranges	mwalshbain	Charts and Charting in Excel	1	May 12th 05 02:31 AM
IRR data in different ranges	GaryF	Excel Worksheet Functions	6	April 29th 05 10:54 PM

All times are GMT +1. The time now is 06:39 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us