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

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