If you want the DD in the rest of the cells, just copy it down? Not really sure what you are trying to do there, seems like you are going in circles - the DD references a range that gets its data from the DD?