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 mailI 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 CasesI 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 CommentsIs 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 boxHi 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 sideI 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 toobarWhen 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 useI 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 dCan 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 2003we 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 positionHi, 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 messagesHelp, 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 RangeI 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 WordOutlook 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 nameI 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 InstallI 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 excelI 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: fieldI 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 ExcelI 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 ...