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

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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