ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Naming Ranges (https://www.excelbanter.com/excel-programming/393090-naming-ranges.html)

[email protected]

Naming Ranges
 
Hi all,

i have a range of six columns that data is entered to
(ID,Name,Position,Department,Salary,Overtime) and I want the name of
the range expand everytime i enter a new record as all filled cells
are included in the range and blank cells are ingored.

I thank you in advance and i really appreciate your help

regards,
naweed


Gary Keramidas

Naming Ranges
 
check debra's site

http://www.contextures.com/xlNames01.html#Dynamic

--


Gary


wrote in message
ups.com...
Hi all,

i have a range of six columns that data is entered to
(ID,Name,Position,Department,Salary,Overtime) and I want the name of
the range expand everytime i enter a new record as all filled cells
are included in the range and blank cells are ingored.

I thank you in advance and i really appreciate your help

regards,
naweed





All times are GMT +1. The time now is 09:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com