how to gave comments to multiple cells at a time

macropod · #1 02-06-2012, 08:34 PM

I have merged your three threads about adding comments to multiple cells. Please don't start multiple threads on the same topic - if you have additional information/questions, add them to the original thread.

gsrikanth · #2 02-06-2012, 11:37 PM

Quote:

Originally Posted by macropod

I have merged your three threads about adding comments to multiple cells. Please don't start multiple threads on the same topic - if you have additional information/questions, add them to the original thread.

ok thanks regards

gsrikanth · #3 02-07-2012, 02:05 AM

above code is comming for value 1 i want to general lies comming error need some correction

Code:

Sub AddComments()
Dim ocel As Range 
For Each ocel In Selection.Cells
  If Len(ocel.Value) > 0 Then
    ocel.AddComment "Comment Text"
  End If
Next
End Sub

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro to Insert Text Into Cells Having Multiple Lines	revans611	Excel Programming	4	10-24-2011 10:15 AM
Multiple VLOOKUP's checking multiple Cells	OTPM	Excel	11	05-23-2011 11:18 AM
Concatenate/merge contents of multiple cells	PSYloco	Excel	2	05-14-2011 03:46 PM
filling multiple cells whislt using Filter	VinceO	Excel	1	05-09-2011 06:38 AM
How to get cells to calculate time?	jrasche2003@yahoo.com	Excel	2	02-09-2007 07:10 AM