I think we need some more background - is it a 1 or 2 dim array, do you
merely wnt to blank out the entry or actually delete it.

If its 1 dimensional, then the "Filter" function should be useful. If its
2d I think you will have to resort to more VBA.

Please also see:

http://www.ozgrid.com/forum/showthread.php?t=30439

"Patachoup" wrote:

Hello,

How to easily erase an single array element returning "Error 2042" using VBA
code ?

Thx in advance