a named range with more than seperated range

[clarksonneo]

Hi,

This is not a VBA question.

How to create a named range which refer to cell A1, cell A2 and A4, but exclude A3?

[Bob Phillips]

Just select the cells and type the name in the name box.

[clarksonneo]

Just select the cells and type the name in the name box.

not work

define name --> new name
at the refers to, the text is =Sheet1!$A$1:$A$2,Sheet1!$A$4

[Bob Phillips]

That is not what I said.

[Aussiebear]

Select the non contiguous cells in the range, right click and name the range