Retrieving comment using range name

I have singular cells in different places referenced by their range
names.  Is there a way to get the comments corresponding to the
referenced ranges (singular cells)?
Thanks in advance,
Tomek

0
tpolak (59)
10/20/2005 8:48:36 AM
excel.misc 78881 articles. 5 followers. Follow

2 Replies
987 Views

Similar Articles

[PageSpeed] 1

Set testrng = Range("A3:A4", "C3:C4")
comment1 = testrng(1).Comment.Text
....
commentn = testrng(n).Comment.Text

Stefi

„topola” ezt írta:

> I have singular cells in different places referenced by their range
> names.  Is there a way to get the comments corresponding to the
> referenced ranges (singular cells)?
> Thanks in advance,
> Tomek
> 
> 
0
Stefi (275)
10/20/2005 10:20:02 AM
did you mean, 

asin having a cell C4 named Myrange, 

a cell C5 containing the word Myrange

and a cell C5 having the formula =Indirect(C5) 

which reflects the data from cell C4, the single cell named rang
referenced in C5



topola Wrote:
> I have singular cells in different places referenced by their range
> names.  Is there a way to get the comments corresponding to the
> referenced ranges (singular cells)?
> Thanks in advance,
> Tome

--
Bryan Hesse
-----------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2105
View this thread: http://www.excelforum.com/showthread.php?threadid=47781

0
10/20/2005 10:27:42 AM
Reply:

Similar Artilces:

How do I name a range and then have that range be dynamic?
I want to select the entire contents of a worksheet, but that data set will change each time I open it as records will be added to it every day. I want to always choose all records, and there will never be any non-contiguous rows in the data or blank rows in it. So I can make a direct call to it and always get all of it by way of the named range. If A1 is the header for example for the first column you can use Range("A1").CurrentRegion.Select The same as Ctrl * -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "CellShocked" <ce...

Always uses default account when sending mail
I have several accounts configured in Outlook 2003 SBE. If I have composed a message and I use the Accounts button to change the account used. Outlook then displays which account will be used for sending the message; this is another than the default one. When I send the message, it still uses the default account to send it, I see this when I test it. What is the matter? Cheers, Thorbjorn I appear to be having a similar problem under Outlook 2003 on a new XP system. I've configured in multiple email POP accounts. Usually if I send just one email at a time, it will retain the default...

Using Workflow to Notify Salespeople of Open Cases
I follow the instructions from the article : http://www.microsoft.com/dynamics/crm/using/services/notifyopencase.mspx But the mail is send to the owner of the Case ( the CSR ) and not to the owner of the Account which is regarding to the Case ( the Salespeople ). Could anyone help ? ...

Linking Comments
Is there a way to link a cell value and comment to a cell in another workbook so that it shows up exactly the same as the original? I know how to link cells, but the comments don't come across in the link. Hi Heidi formulas can only eturn values. So you can't link comments -- Regards Frank Kabel Frankfurt, Germany heidi wrote: > Is there a way to link a cell value and comment to a cell > in another workbook so that it shows up exactly the same > as the original? I know how to link cells, but the > comments don't come across in the link. Further to Frank you...

How to retrieve the string from dialog box
Hi All, Does anyone know how to retrieve a string in IDC_STATIC on a dialog box? I have to print out a report with an application version at the bottom line for users to be aware of it in my application. I don't know how to retrieve the string in IDC_STATIC control on a dialog box. It would be very nice that someone let me know how to do that without calling the dialog box. TIA Hwasoo Lee Back 9 wrote: > Hi All, > > Does anyone know how to retrieve a string in IDC_STATIC on a dialog box? > I have to print out a report with an application version at the bottom line &g...

Can I paste information (from several cells) into a cell comment?
...

comment in jscript of Microsoft CRM client side
I am facing problems when i use comment in OnChange event. first i use "//" and i use IE 6, my script work properly. But yesterday, my company just rolled out IE 7, then i need to update my script by adding more funtions, after i try to run the script , it did not work. i try to debug. Finally the last chance is i change comment from "//" to "/* */", the result is my script work properly again. So from this,anyone had same experiences ? or any suggestion what is happening with comments style i have to use. Thanks, Amnouy Hi, I have used IE 7 with CRM 3....

Anyone using FRx Forecaster?
Anybody using FRx Forecaster 7.0? We're looking to purchase it, and we'd like to talk to a few users to find out how it's working for them. Also, anyone know who would offer training classes for it near St. Louis? Thanks! -- Bud Cool Microsoft Certified Business Management Solutions Specialist, GP 9.0 Financials Currently supporting: GP 9.0, SP2 ...

Using the combo box from the forms toobar
When using the combo box from the forms toolbar I get text that is a specified size. I can increase the size of the drop down arrow and box but I can't change the text size. How do I change the text size? Hi R, > When using the combo box from the forms toolbar I get text that is a specified size. I can increase the size of the drop down arrow and box but I can't change the text size. How do I change the text size? You can't. The combo box from the forms toolbar is a fixed font. If you need a different font, you'll have to use the combobox from the control toolbox. Re...

ActiveX Timer control use
I need more than one timer on a form, so I'm trying to learn how to use the ActiveX Timer control in an Access 2002 form. Here's a snip of my test code: Private Sub cmdTest_Click() Dim bEndTimer4 As Boolean Forms!frmMain!Timer4.Interval = 4000 'Approx 2 Seconds bEndTimer4 = False Forms!frmMain!Timer4.Enabled = True Do DoEvents Sleep 5 Loop Until bEndTimer4 = True 'Forms!frmMain!Timer4.Enabled = False If bEndTimer4 = True Then MsgBox "Timer Timed and Period Ended" Else MsgBox "Timer D...

retrieve an AVERAGE of a range using VLOOKUP to locate start/end d
Can I calculate the average of a range based on VLOOKUP? In other words, can I get Excel to "look up" the respective START / END dates of an investment position listed in Sheet 1 and then go and locate those 2 distinct cell values in in a different sheet (Sheet 2) utilizing VLOOKUP function and then return the calculated AVERAGE of the cells within that range back into Sheet 1? Appreciate any thoughts if doable in Excel in any way? tAKE A LOOK AT AverageIFS and see if that does what you want. If it were me, I'd probably enter the formula manually, record the resu...

Problems using exchange server 5.5 sp3 with outlook 2003
we are using exchange server 5.5 sp3 with outlook 2003 and experiencing the following problem: The problem is that once the outlook shared contact file was placed on a shared server, employees discovered that when an invitation is sent out to other members it would not come up as a "decline" or "accept" message but just as a plain text message informing them of a meeting. Any suggestion? Thanks Pete wrote: > we are using exchange server 5.5 sp3 with outlook 2003 and > experiencing the following problem: > > The problem is that once the outlook shared contact...

Why won't Publisher let me use my OMR bubble font?
I am creating scanable forms to use with an OMR program. The program comes with an OMR bubble font (i.e. bubbles with little letters or numbers in them). The font is installed on my computer and every other program seems to have no problem using it but when I try to use it in publisher in a text box the text simply reverts to some other font (normally Times New Roman). I really would like the design capability of publisher but if it won't use my font it will be a real drag. When does it revert to another font? After exiting the text bos, after printing, etc? -- JoAnn Paules MVP ...

Retrieve mouse position
Hi, I am writing an app in which I need to retrieve the mouse coordinates even when it mouse is outside the main frame. How do I do it? Thanks! xg >Hi, I am writing an app in which I need to retrieve the mouse coordinates >even when it mouse is outside the main frame. How do I do it? Thanks! Have you tried calling GetCursorPos? If you want to know when the mouse is moving I think you'll need to use a hook - have a look at SetWindowsHookEx WH_MOUSE. Dave IN addition to David's answer, you have not stated the problem you are trying to solve. For examp...

How to make a stacked bar chart using time?
Hi, I have the following data to plot on a stacked bar chart, and displayed as time. Dr X Dr Y Dr Z 02:03 03:00 01:00 00:20 02:00 00:30 00:40 01:00 00:30 02:45 01:00 00:15 02:10 08:13 07:00 02:00 This is time in hours and minutes. I need the result to look like this... Dr.X bar [02:03][00:20][00:40][02:45][00:15][02:10] Dr.Y bar [03:00][02:00][01:00][01:00] Dr.Z bar [01:00][00:30][00:30] where [02:03] represents a colour to represent 2 hrs & 3 mins etc. If I just select the Dr. X data I can get a stacked chart, but as soon as I add either Dr. Y or Dr. Z data the whole chart ...

Retrieving messages
Help, I mistakenly restored all the defaults on Outlook (the computer did not crash) losing all the messages and address book. I have had to set up the application from scratch entering account details etc. Question is: are all the messages and contacts still held on the computer even the program needs to be set up again and, if so, how do I retrieve them. Any assistance greatly appreciated. Thanks. P89 If you made a backup of your system or My Documents, search for a file called Outlook.pst. If you have that you can import all the information. Al "peterson89" <peterson...

Hlp! Insert Symbol based on Range
I am creating a report that includes weight, blood pressure, etc. and have to show a different picture (or symbol) that indicates Fine, Could be better, Needs attention, for example. So, I need a way to look at their result, compare it with normal ranges and then have the correct picture appear. Any ideas would be greatly appreciated! -- Thanks! Dee You likely could use an expression in the Picture property of an Image control in the repor; for examplet: =IIf([FieldName] Between "One Value" And "Another Value", "C:\FolderName\GoodPicture.bmp", IIf([F...

Template using Word
Outlook 2003, Word 2003 I want to use Word as my email editor, and also set up a standard template. This would achieve the following things: Use standard styles Use Word fields, so recipient name is filled in automatically Possibly use Word macros ...

Retrieving comment using range name
I have singular cells in different places referenced by their range names. Is there a way to get the comments corresponding to the referenced ranges (singular cells)? Thanks in advance, Tomek Set testrng = Range("A3:A4", "C3:C4") comment1 = testrng(1).Comment.Text .... commentn = testrng(n).Comment.Text Stefi „topola” ezt írta: > I have singular cells in different places referenced by their range > names. Is there a way to get the comments corresponding to the > referenced ranges (singular cells)? > Thanks in advance, > Tomek > > did yo...

SOS! SharePoint Install
I downloaded SharePoint Services 2.0 and installed it on my Windows Server 2003 Std. server where CRM 3.0 is installed. Now, I can't use CRM. When I double click the icon I get a message that says "The Server is Unavailable". Major disaster! Does anyone have any ideas? Thanks in advance. Did you reboot the server? "Lloyd" wrote: > I downloaded SharePoint Services 2.0 and installed it on my Windows Server > 2003 Std. server where CRM 3.0 is installed. Now, I can't use CRM. When I > double click the icon I get a message that says "The Server is...

Wrong answer after using the payment formula in excel
I am trying to get a monthly payment figure by using the payment formula in excel. It always calculates the payment incorrectly. I try it on my financial calculator, as well as a financial program I have in the computer and these two come up with the same figure. Then I try it in excel, the answer is different. the formula I am using is: =PMT(.0015,360,375,000) Any help?? What are the answers you get in each environment. FWIW, I calculate my mortgage payments using PMT and they are correct. -- Regards - Andy Wiggins FCCA www.BygSoftware.com Excel, Access and VBA Consultancy &q...

Display name in To: field
I have recently changed from 98 to XP and could always address my contacts as per company name, not firstname / lastname. The XP default is auto-set to firstname/lastname but I desperately need to change that so when I address an e- mail I get all of the company field options, not first name / lastname. HELP! I have 800 contacts of which I don't want to have to re- type all company details into the name section...? Tools->Email Accounts->Directories->View or Change. Set your display name at the bottom. In Outlook, Tools->Options->Contacts. Set your options there ...

In Excel
I want to effect a mass change to the sign of numeric values in a range of cells (rows and columns). put -1 in an empty cell, copy it, select the range of cells to be modified, select Paste Special and pick Multiply. MaryKaye wrote: > I want to effect a mass change to the sign of numeric values in a range of > cells (rows and columns). Put -1 in an un-used cell and copy it. Then select the cells you want to update and: Edit > PasteSpecial > multiply -- Gary''s Student - gsnu201001 "MaryKaye" wrote: > I want to effect a mass ch...

Using OR in Condition Formatting
Hi all, I'm trying to use OR in a piece of condition formatting. Basically, want a cell to go red if it has either "high" or "red" in it. I'm using the following formula, but it doesn't seem to work: =OR("red","high") Any ideas why this doesn't do what I want? TIA, Samuel -- Samuel ----------------------------------------------------------------------- SamuelT's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2750 View this thread: http://www.excelforum.com/showthread.php?threadid=48280 You might wa...

Problem using Public Folders
Hello people I'm having a problem with Public Folders in Exchange 2003. From Outlook, I can see the public folders, and from ESM I can also see all the groups on the Storage Group The problems are that I can't see the folders on ESM under the "Folders" tree, inside my Administrative Group, and neither can I see the System folders (it shows the error with an id of c1030af1 - forbidden). This way, no one can see, e.g., each other's availability on Calendar for meetings Can anyone shed a light to me? I've checked some documents on the net and Microsoft's ...