DrPepper
06-30-2009, 06:05 PM
How can I delete a row without effecting a Defined Name?
I have a range (B2:B47) setup as a Defined Name, which I use as a Data Validation List. When I delete a row, say row 7, it changes my Defined Name range to (B2:B46). So now if I fill my B column up to 47... the last name will not show up in my drop down list.
Very frustrating... any help would be appreciated.
I have a range (B2:B47) setup as a Defined Name, which I use as a Data Validation List. When I delete a row, say row 7, it changes my Defined Name range to (B2:B46). So now if I fill my B column up to 47... the last name will not show up in my drop down list.
Very frustrating... any help would be appreciated.