vas Shevde
> *Sent:* Friday, November 29, 2013 11:11 AM
>
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Comments
>
>
>
> Dear Ravindra & Pankaj
>
> Marvelous job done ,really great.
>
> Can I get little more help
>
> Wi
ards
Shrinivas
On Thu, Nov 28, 2013 at 12:37 PM, Ravinder wrote:
> Pfa….
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Shrinivas Shevde
> *Sent:* Thursday, November 28, 2013 11:53 AM
> *To:* excel-macros@googlegroups.
Pfa..
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Shrinivas Shevde
Sent: Thursday, November 28, 2013 11:53 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Comments
Waiting for Reply
On Wed, Nov 27, 2013 at 2:18 PM
Please try the below code.. Hope this will help Shrinivas..
Sub showcomments()
Application.ScreenUpdating = False
Dim commrange As Range
Dim mycell As Range
Dim curwks As Worksheet
Dim newwks As Worksheet
Dim i As Long
Set curwks = ActiveSheet
On Error Resume Nex
Waiting for Reply
On Wed, Nov 27, 2013 at 2:18 PM, Shrinivas Shevde wrote:
> Dear all
> I have excel sheet in which I added comments in many cell.
> I want to get all the comments in row one below another may be any order.
> In one sheet there are more than 40 comments and such I have 16 to 18
part de* Cab Boose
> *Envoyé :* mardi 19 juillet 2011 22:56
>
> *À :* excel-macros@googlegroups.com
> *Objet :* Re: $$Excel-Macros$$ Comments Boxes - Temporary Zoom In
>
> ** **
>
> Hi Daniel
>
>
>
> Sorry to say, still doing the same thing.
>
>
cel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> *De la part de* Cab Boose
> *Envoyé :* mardi 19 juillet 2011 06:27
>
> *À :* excel-macros@googlegroups.com
> *Objet :* Re: $$Excel-Macros$$ Comments Boxes - Temporary Zoom In
>
> ** **
>
> Hi Daniel**
try this
Sub reduce()
Dim a As Range
For Each a In Cells.SpecialCells(xlCellTypeComments)
a.Comment.Visible = False
a.Comment.Shape.TextFrame.AutoSize = True
Next a
End Sub
On Tue, Jul 19, 2011 at 9:56 AM, Cab Boose wrote:
> Hi Daniel
>
> Thanks for a great result. Not quite there yet.
Hi Daniel
Thanks for a great result. Not quite there yet. When double click the
comment box doubles it size. When cursor is moved away from that cell and
then back to that cell the double size is still there sometimes. Sometimes
it does go back to normal but not all the time.
So when the comm
