Using variable names for cells
I seem to remember a technique where I could assign a variable name to
the contents of a cell so that whenever I wanted to use the contents,
all I had to do was call up the variable name. Unfortunately I cannot
find the way to set up the process. Any suggestsions or ideas would be
appreciated. Thanks and a Happy New Year.
Take out the trash to reply
dim rng as range
> I seem to remember a technique where I could assign a variable name to
>...Voting Buttons Tracking Not Working (Outlook 2003)
I've seen some replies to this question/problem but for me it did not work when trying the Form Publish. Is there anything else I can do?
EggHeadCafe - Software Developer Portal of Choice
XML/XSL VB Tester
Replies to what question/problem? Describe what you're seeing in detail.
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
<murray gree...How do I use excel names with INDIRECT with charts
I want to create a Chart that does not directly reference cell-ranges (i.e.
but excel-names that make the reference sheet-independent.
My aim is to be able to copy one chart to other worksheets, which have their
dataareas at the same places like the source-sheet.
Problem: This works fine in cells but not in charts
Excel name definition:
Any idea about this?
Thanks in advance,
You have to include the sheet name in the final formula that you want XL to
www.tushar-mehta.co...SBS2003 + Internet Explorer
We have a customer who has an SBS 2003 Premium server with ISA 2004
They have just installed a bolt on to Outlook which searches their mailboxes
They have discovered that they cannot get this to work unless the untick the
'Use automatic configuration script' in Internet Explorer.
Trouble is each time they re-boot a PC the tick comes back, so sounds like
it's a policy setting somewhere.
What is this ?
Where is it configured and what are the implications of turning it off ?
Could it be that rather than turn it off whatever it is ought to be
con...Number format #3
Ah, works perfectly. Thanks
carg1's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1527
View this thread: http://www.excelforum.com/showthread.php?threadid=27578
...Outlook's Restore Down Button
I am using Outlook 2003 with Windows 7 and dual monitors. I normally click
on the restore down button so that I can stretch outllook over the two
monitors. All of a sudden I am experiencing a problem. When clicking on the
restore down button, the only thing that is shown is a title bar, i.e.,
"Inbox - Microsoft Outlook". The bar can be resized horizontially, but not
vertically. None of the information that exists below the title bar can be
seen. When I hit maximize then everything reappears, however Outlook is only
shown on the one monitor. When clicking on resto...Lookup a range of numbers
I have a table as follows:
(Dist) 64k 128k 256k
5 1000 1200 1500
10 1600 1700 1800
15 2000 2100 2200
I'd like to have a formula whereby if I key in a Distance of 4 and a speed
of 256k, the active cell will show "1500".
I tried to use sumproduct but seems like sumproduct can only be used if the
Dist is exactly "5", "10", etc. The only alternative I can think of is to
list out ALL the integers for Distance. But, is there an easier way?
...Help, urgent, connection to access database
I met a problem about access database connection.
I have a program reading data from access database through ODBC.
When the access database located on local server, and created ODBC
linked to local database,the program runs without problem, but if it is a
network shared database, and created ODBC linked to the shared database, the
program prompts error: "workgroup file is missing".
Yes, I used workgroup file in current database and set correct security.
So what's the problem? is problem of the ODBC drive?
you should not be using ODBC
Access stop...From Database to XML
I have a simple database with address information about a member...
I must get that information in a xml document on the server, and then
read it again, without saving it locally....
This is what database is like:
Member - Name - Street - Number - Zipcode - City - Land
Can somebody help me out?
I`m one step further than i was....
Now i have all the address information in a DataSet, and all his
further information in another DataSet...
How can i get those two DataSets in the XML Document??
Can somebody help me come any further??
> I have a simple d...Access 97 to Access 2003 DataBase conversion 08-30-07
We work in a mostly french environment. We have a standard image using MUI
Microsoft products (XP and Office 2003 are MUI) Since the convertion of an
ACCESS 97 BD into Access 2003, we experience a sort sequence problem when
DoCmd.Openform or DoCmd.ApplyFilter
A selection on a name like "Cot�" will return no record. Asking for "Cote"
will return all records including "Cot�".
I suspect a problem with MUI (multi-user interface) but I did not find any
recommandation at Microsoft.
"Jacques Tr�panier" <firstname.lastname@example.org>...Combine variable number of columns
I have a single spreadsheet with a list of clients, addresses and their
product interests. This table will be used to drive a Mailmerge document. In
the document, I want to be able to refer to the products in which they
indicated an interest. The problem is that while one client may have
identified only one product (one column) others have selected anywhere from
two to 170 products - each product is in a separate column. I can join two
columns with "&", but when I have an inconsistent number of columns how do I
do this efficiently? - I will have to do it for each client, e...Number to text conversion ......HELP
I need help in converting formula calculation ( Number or Currency ) into
EQ. Result = 2,500.00 converting to .....two thousand five hundred..
Check http://www.mvps.org/access/modules/mdl0001.htm at "The Access Web"
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
"Eko Hery" <email@example.com> wrote in message
> Dear Friend..
> I need help in converting formula calculation ( Number or Currency ) into
> EQ. Result = 2,500.00 con...Maximum number of characters in a cell
Is there a way to format a cell so that it can contain more than 255
> Is there a way to format a cell so that it can contain more than 255
A cell can contain about 32000 characters, but Excel will display only
about a 1000 of them (depending on font and fontsize).
Jan Karel Pieterse
If you would add some forced (manual) line breaks (<Alt> <Enter>) in your
text at opportune locations, you will find that you can *display* much more
----------------------------------...Manufacturing BOM Where Used query
Winthin manufacturing there is a where-used inquiry window that will show all
BOMs that a given item appears in. You can also expand that view to see what
BOMs and item's parent is used in. Some of our BOMs are 10 layers deep.
In our environment we need to know which category of finished goods each
purchased item is used in. Currently we maintain this manually and store the
info in an inventory user-defined field. Over time as the number of our
finished goods and purchased parts has increased this has become an
I need to find a way to query the BOM tables a...can cvs files be opened using excel viewer
i have a user who cannot open cvs files with excel viewer but can ope
with the full version of excel...anyone experienced this problem and i
so, can you pls post the resolution
darriel's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2388
View this thread: http://www.excelforum.com/showthread.php?threadid=37522
There is nothing in the description of the Excel Viewer to suggest that it
can read anything other than true XLS files.
http://support.microsoft.com/default.aspx?scid=kb;...My database has suddenly locked up
My database has suddenly locked up. I keep getting this message when I
try to add a new module:
The database has been placed in a state by user <name> on machine
<name> that prevents it from being opened or locked. (Error 3734)
What happened? How do I unlock the thing?
Is the user name and machine in the message you? If so, close you mdb and
look in the same directory for an ldb file. If it exists, delete it.
Dave Hargis, Microsoft Access MVP
> My database has suddenly locked up. I keep getting this message when I
> tr...How do I count the number of times a particular charcter ("." say)
How do I count the number of times a particular charcter ("." say) appears in
For example, ABC.18.104.22.168 should retun 4.
Is there a formula?
(remove nothere from the email address if mailing direct)
"RH" <RH@discussions.microsoft.com> wrote in message
> How do I count the number of times a particular charcter ("." say) appears
> a cell.
> For example, ABC.22.214.171.124 should retun 4.
> Is there ...How to prevent the same program from running twice using vc?
Try this: http://www.codeguru.com/Cpp/misc/misc/article.php/c299
Ajay Kalra [MVP - VC++]
"LeeTow" <firstname.lastname@example.org> wrote in message
Checkout Bob's tip on this subject at
Check Abdoul [VC++ MVP]
"LeeTow" <email@example.com> wrote in message
See also my essay on my MVP Tips site.
On Wed, 8 Sep 2...Accelerator key problem on custom button
I added custom menu button with unique accelerator key on it (Map&e). But,
accelerator key do not work on it. Is it possible to enable it?
Office 2003 (11.8010.6568)
If it doesn't work, the most likely explanation is that there is another =
visible command with the same accelerator.=20
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
and Microsoft Outlook Programming - Jumpstart for=20
Administrators, Power Users, and Developers
"Tom...Utilizing the Print Preview without using a printer
How can I use the Print Preview function and make any necessary changes to my
worksheet?..I currently do not have a printer installed, but would still like
to be able to have access to the Print Preview functions before I actually
print my worksheet.
Just install *any* print driver that might be resident on your system, and
XL will then enable the "PrintPreview" feature, even though no actual
printer is present.
Please keep all correspondence within the Group, so all may benefit!
==========================================...Searching for variables in excel database
I have an excel database ( 10 columns x 1500 rows ) and I want to be
able to have a search function on a seperate worksheet. I want the
search function to work like the autofilter function, but this way
could be more appealling to the eye. Any tips on how to achieve this
Gavin77's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25824
View this thread: http://www.excelforum.com/showthread.php?threadid=392161
...Microsoft Office X cannot start because MS Office is already in use
Sometimes Entourage 10.1.4 shows the message:
"Microsoft Office X cannot start because MS Office is already in use.
A Office program is being used by MYNAME. Your installation exceeds..."
It's crazy because I'm the only user with OSX (10.3.2) and Office X is
installed only on my Mac!!!
It seems that it happens when Entourage run scheduled actions (i.e. Send
Pls help me.
...Date & Control Button Focus
I have a form that has the calendar in it and 3 buttons that represent 1st,
2nd, and 3rd shift. We input up to 50 forms per day. The forms may be
entered the next day. The calendar will always go to todays date because of
the code Now() used. How do I make the date stay at the last date that was
enetered? How do I make the 1st, 2nd, and 3rd shift buttons stay at last
shift selected after data has been entered? This would allow the data entry
person not to have to change date or shift if forms are grouped together.
"The calendar will always go to t...MSAccess 2007 database corruption
One of our program which is in all the computers( having different operating
system ) has accdb file as backend database. Multiple operations such as
saving, deleting, adding etc. are done simoultaneously. During this the
database gets corrupted periodically resulting in unrecodnised database
format error or records having #ERROR and loss of data. If we compact and
repair the database we loose the precious data.
The product is developed using microsoft visual basic 6.0 and our
development team put in regorous effort in finding out the cause to the
problem and hence came out with certa...Using a value from a cell inside a formula!
I've got two cells that contain the start and end row of a matrix in
I want to use these row numbers in a =COUNT.IF formula to count th
number of specified instances in this matrix.
But my problem is this; how can I use the values in the two cell
inside the COUNT.IF formula??
I should look something like this;
As you can see, the column (F) is specified in the formula but the ro
number needs to be fetched from cell1 and cell2.
Can anyone help me with the correct syntax?