Cell Selection Macro in Word Help

[brentt03]

Hello all!

I have a document in which I need to select a cell, add comment, select next cell, add comment, etc

I was wanting to make a macro to automatically do this for me, problem is the tables vary by overall number of rows, and they will never be the same. Is there a way to create a macro to do this for me?

Also if I select row 1, column 1 and add a comment, then i will need to select row 1, column 2 to add a different comment.

This code works, but doesn't give me range

Sub Macro1()
'
' Macro1 Macro
'
'
ActiveDocument.Tables(1).Columns(2).Cells(1).Range.Select
Selection.Comments.Add Range:=Selection.Range
Selection.TypeText Text:="rn"
ActiveDocument.Tables(1).Columns(2).Cells(2).Range.Select
Selection.Comments.Add Range:=Selection.Range
Selection.TypeText Text:="rn"




End Sub

[macropod]

Try something based on:

Please Login or Register  to view this content.

As coded, the macro starts from wherever your insertion point is - meaning you can exit & re-start later - and you can skip over cells you don't want to add comments to.

[macropod]

Cross-posted at: http://www.vbaexpress.com/forum/show...o-in-Word-Help
Please read Excel Forum's Cross-Posting policy in rule 8: http://www.excelforum.com/forum-rule...rum-rules.html