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

#14

02-07-2012, 11:04 PM

macropod

Windows 7 64bit how to gave comments to multiple cells at a time

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,467

I can't see why you'd want to add the same comment to all such cells but, if that's what you want, try:

Code:

Sub AddComments()
Dim ocel As Range
On Error Resume Next
For Each ocel In ActiveSheet.UsedRange.SpecialCells(xlCellTypeConstants)
  ocel.Comment.Delete
  ocel.AddComment "Comment Text"
Next
End Sub

Note that this code will replace any existing comments. If you don't want to do that, delete or comment-out the 'ocel.Comment.Delete' line.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

« 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 09:19 AM.