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 |
All times are GMT +1. The time now is 08:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com