Thread: Export cell comment as a data cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Export cell comment as a data cell
You can use this macro found at Debra Dalgleish's site to extract the comments'
contents to an adjacent column.

http://www.contextures.com/xlcomment...l#CopyAdjacent


Gord Dibben MS Excel MVP

On Mon, 5 Nov 2007 15:31:27 -0800, KADL wrote:

I am importing Excel data into an Access database. Is it possible to put
cell comments into a column of their own? I need both the field data and the
comments.

Thanks!

Reply With QuoteReply With Quote