Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing Comments & Cell Reference
Greetings:
We have a document that we want to print comments on a seperate page. That is easy - what I cannot figure out is how to change the "cell" reference that is printed from an actual cell reference such as B7 to what that cell says such as "budget". I know I could turn on the column and rows show they show when printing but the user would not like to do that. Can someone please assist? Is what I want to do even possible? Thanks Jennifer |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing Comments & Cell Reference
do you think use the first line of the coment box to put Budget?
it will show as: Cell: B7 Comment: Budget Here is your comments hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Jennifer L." escreveu: Greetings: We have a document that we want to print comments on a seperate page. That is easy - what I cannot figure out is how to change the "cell" reference that is printed from an actual cell reference such as B7 to what that cell says such as "budget". I know I could turn on the column and rows show they show when printing but the user would not like to do that. Can someone please assist? Is what I want to do even possible? Thanks Jennifer |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing Comments & Cell Reference
I was hoping to put the work "Budget" where B7 is located. Is that possible?
"Marcelo" wrote: do you think use the first line of the coment box to put Budget? it will show as: Cell: B7 Comment: Budget Here is your comments hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Jennifer L." escreveu: Greetings: We have a document that we want to print comments on a seperate page. That is easy - what I cannot figure out is how to change the "cell" reference that is printed from an actual cell reference such as B7 to what that cell says such as "budget". I know I could turn on the column and rows show they show when printing but the user would not like to do that. Can someone please assist? Is what I want to do even possible? Thanks Jennifer |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing Comments & Cell Reference
sorry but I do not have a clear understand.
Are you looking for "replace" the cell address (name) from B7 to Budget? -- regards from Brazil Thanks in advance for your feedback. Marcelo "Jennifer L." escreveu: I was hoping to put the work "Budget" where B7 is located. Is that possible? "Marcelo" wrote: do you think use the first line of the coment box to put Budget? it will show as: Cell: B7 Comment: Budget Here is your comments hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Jennifer L." escreveu: Greetings: We have a document that we want to print comments on a seperate page. That is easy - what I cannot figure out is how to change the "cell" reference that is printed from an actual cell reference such as B7 to what that cell says such as "budget". I know I could turn on the column and rows show they show when printing but the user would not like to do that. Can someone please assist? Is what I want to do even possible? Thanks Jennifer |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing Comments & Cell Reference
That is exactly what I am looking for, to "replace the cell address B7 to the
word Budget. The word Budget is the contents of cell B7. Thanks for following up, any ideas on how to accomplish this? Thanks Jennifer "Marcelo" wrote: sorry but I do not have a clear understand. Are you looking for "replace" the cell address (name) from B7 to Budget? -- regards from Brazil Thanks in advance for your feedback. Marcelo "Jennifer L." escreveu: I was hoping to put the work "Budget" where B7 is located. Is that possible? "Marcelo" wrote: do you think use the first line of the coment box to put Budget? it will show as: Cell: B7 Comment: Budget Here is your comments hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Jennifer L." escreveu: Greetings: We have a document that we want to print comments on a seperate page. That is easy - what I cannot figure out is how to change the "cell" reference that is printed from an actual cell reference such as B7 to what that cell says such as "budget". I know I could turn on the column and rows show they show when printing but the user would not like to do that. Can someone please assist? Is what I want to do even possible? Thanks Jennifer |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing Comments & Cell Reference
i do not have sucess trying named cell.
I think this is possible with code. -- regards from Brazil Thanks in advance for your feedback. Marcelo "Jennifer L." escreveu: That is exactly what I am looking for, to "replace the cell address B7 to the word Budget. The word Budget is the contents of cell B7. Thanks for following up, any ideas on how to accomplish this? Thanks Jennifer "Marcelo" wrote: sorry but I do not have a clear understand. Are you looking for "replace" the cell address (name) from B7 to Budget? -- regards from Brazil Thanks in advance for your feedback. Marcelo "Jennifer L." escreveu: I was hoping to put the work "Budget" where B7 is located. Is that possible? "Marcelo" wrote: do you think use the first line of the coment box to put Budget? it will show as: Cell: B7 Comment: Budget Here is your comments hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Jennifer L." escreveu: Greetings: We have a document that we want to print comments on a seperate page. That is easy - what I cannot figure out is how to change the "cell" reference that is printed from an actual cell reference such as B7 to what that cell says such as "budget". I know I could turn on the column and rows show they show when printing but the user would not like to do that. Can someone please assist? Is what I want to do even possible? Thanks Jennifer |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing Comments & Cell Reference
This macro from Debra Dalglesih will place comments, addresses and contents on a
new sheet. Sub ListComms() Dim Cell As Range Dim sh As Worksheet Dim csh As Worksheet Set csh = ActiveWorkbook.Worksheets.Add csh.Name = "Comments" For Each sh In ActiveWorkbook.Worksheets If sh.Name < csh.Name Then For Each Cell In sh.UsedRange If Not Cell.Comment Is Nothing Then With csh.Range("a65536").End(xlUp).Offset(1, 0) .Value = sh.Name & " " & Cell.Address .Offset(0, 1).Value = Cell.Comment.text End With End If Next Cell End If Next sh End Sub Gord Dibben MS Excel MVP On Wed, 25 Jun 2008 12:04:00 -0700, Jennifer L. wrote: Greetings: We have a document that we want to print comments on a seperate page. That is easy - what I cannot figure out is how to change the "cell" reference that is printed from an actual cell reference such as B7 to what that cell says such as "budget". I know I could turn on the column and rows show they show when printing but the user would not like to do that. Can someone please assist? Is what I want to do even possible? Thanks Jennifer |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing Comments | Excel Discussion (Misc queries) | |||
How do I reference the comments of a cell? | Excel Discussion (Misc queries) | |||
changing the cell name when printing comments | Excel Discussion (Misc queries) | |||
Printing Comments | Excel Discussion (Misc queries) | |||
Can I reference comments by Cell Name? | Excel Discussion (Misc queries) |