|
Dynamic Range
I have created a dynamic range named "Result1" using the following formula
=OFFSET(dBase1!$G$31,,,dBase1!$A$29,19) Why does this named range not show up in the "Name Box"? Is there any way I can have it highlight to satisfy me that it is indeed covering the range I require? Sandy |
Dynamic Range
Defined named ranges do NOT show. you may goto the name box and type in the
name and see the selection. -- Don Guillett Microsoft MVP Excel SalesAid Software "Sandy" wrote in message ... I have created a dynamic range named "Result1" using the following formula =OFFSET(dBase1!$G$31,,,dBase1!$A$29,19) Why does this named range not show up in the "Name Box"? Is there any way I can have it highlight to satisfy me that it is indeed covering the range I require? Sandy |
Dynamic Range
It was in my head there was a way to do it - Thanks
Sandy "Don Guillett" wrote in message ... Defined named ranges do NOT show. you may goto the name box and type in the name and see the selection. -- Don Guillett Microsoft MVP Excel SalesAid Software "Sandy" wrote in message ... I have created a dynamic range named "Result1" using the following formula =OFFSET(dBase1!$G$31,,,dBase1!$A$29,19) Why does this named range not show up in the "Name Box"? Is there any way I can have it highlight to satisfy me that it is indeed covering the range I require? Sandy |
| All times are GMT +1. The time now is 09:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com