View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Colin Hayes Colin Hayes is offline
external usenet poster
 
Posts: 465
Default Selective concatenation using VBA


Hi

In column A , I have some cells with content , some blank.

In column B , all the cells have content.

I need to transfer the content of the cells in column B to column A ,
BUT ONLY to the cells in column A which are blank.

Cells which already have content in column A should remain unchanged.
Only the blank ones should be updated with the content of the cells from
B.