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
The same as Ctrl *
Regards Ron de Bruin
"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?
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 :
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 ?
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.
formulas can only eturn values. So you can't link 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.
Further to Frank you...How to retrieve the string from dialog box
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.
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.
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?
Microsoft Certified Business Management Solutions Specialist, GP 9.0
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?
> 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
Private Sub cmdTest_Click()
Dim bEndTimer4 As Boolean
Forms!frmMain!Timer4.Interval = 4000 'Approx 2 Seconds
bEndTimer4 = False
Forms!frmMain!Timer4.Enabled = True
Loop Until bEndTimer4 = True
'Forms!frmMain!Timer4.Enabled = False
If bEndTimer4 = True Then
MsgBox "Timer Timed and Period Ended"
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
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.
> 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
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!
>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.
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?
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
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.
"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!
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,
Set testrng = Range("A3:A4", "C3:C4")
comment1 = testrng(1).Comment.Text
commentn = testrng(n).Comment.Text
„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,
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?
> 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)
What are the answers you get in each environment.
FWIW, I calculate my mortgage payments using PMT and they are correct.
Andy Wiggins FCCA
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 /
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.
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.
> 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
Edit > PasteSpecial > multiply
Gary''s Student - gsnu201001
> I want to effect a mass ch...Using OR in Condition Formatting
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:
Any ideas why this doesn't do what I want?
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
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 ...