how to gave comments to multiple cells at a time

		Microsoft Office Forums > Microsoft Excel > Excel Programming
how to gave comments to multiple cells at a time

FAQ

Thread Tools

Display Modes

02-07-2012, 02:05 AM

gsrikanth

Windows XP how to gave comments to multiple cells at a time

Office XP

Competent Performer

Join Date: Dec 2011

Posts: 133

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

Last edited by macropod; 02-07-2012 at 04:04 AM. Reason: Added code tags

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:46 AM.