hi everyone..
can anyone help me in doing something like that :
i don't know hot to make that for separated cells (i mean for example a1, a4, a9 etcc the ones matched by the condition )![]()
ActiveWorkbook.Names.Add Name:="destination" for each cell in range("source") if [contition] then [ADD CELL TO RANGE("destination") end if next
thanks ^_^
Bookmarks