| Thread | Last Post | Replies |
|
| Need Help: Strange, Strange Behavior ( Not Me. My Model! ) | 16 Dec 2007 18:02 GMT | 2 |
I have a strange problem. I'm developing an optimization model in
Excel using an external solver.
* A model run optimizes many separate Events.
* Each Event has a 3 number designation
|
| Name limits | 16 Dec 2007 17:45 GMT | 7 |
I understand that the limits on the number of elements of an array that
can be stored in a Name was 256 columns and 5461 elements in xl2000. In
xl2002 it seems to remain 256 columns, but the number of elements seems
to be upwards of 1,000,000. Is there some source I can go to for ...
|
| NEED MACRO FOR COLOUR BY CONDITIONAL FORMATTING | 16 Dec 2007 17:44 GMT | 9 |
Hi, I have data in coloumn A to coloumn E. (please see below)
A B C
D E
000 B10 G628 000B10G628 54
|
| Range Question | 16 Dec 2007 16:58 GMT | 2 |
Hi all I have some data that I have sorted then subtotal. Is there way I can
search all cells for the highest number then have the higest number cell
change colour?
Many thanks
|
| add a dropdown calendar to a worksheet? | 16 Dec 2007 16:33 GMT | 4 |
I would like to use a simple method to add a dropdown calendar to a worksheet
 Signature
RGGSR
|
| Horisontal scroolbars problems | 16 Dec 2007 14:28 GMT | 3 |
Hav do i remove scroolbars from Listbox on Userform
The len() of values is only 1
http://pmexcelent.dk/Ugeform.xls
|
| makro to log info in Access | 16 Dec 2007 13:11 GMT | 1 |
I want to extract data from a large number of identical spreadsheets. I have
written a program in Access that can extract values from specified cells in
an Excel-file.
I want to specify the Excel-cells in a semi-automated way - to avoid manual
|
| excel files will not down load from outlook | 16 Dec 2007 12:12 GMT | 1 |
excel files in outlook will not down load. I keep receiving an error message
|
| Open a dialog box | 16 Dec 2007 09:37 GMT | 2 |
I've done this before but don't remember how ... I need a script that will
open a particular dialog box and then stop.
Can anyone help?
Thanks so much!
|
| set range error in add sheet | 16 Dec 2007 07:07 GMT | 6 |
I am getting runtime error on below code,anyone can give a hand why
that happens?Thanks in advance.
Sub sukre()
Dim pn
|
| Copying dada from multiple workbooks into 1 workbook | 16 Dec 2007 03:30 GMT | 4 |
I tried searching here for an answer to this problem, but didn't find what
seemed like an appropriate solution... (Unless I am looking at it wrong...)
I have a folder with over 360 files I need to copy A to C and colums AE, AG,
AI and AK if data is present in these colums I would ...
|
| difficulty with percentage from worksheet as seen by VBA | 16 Dec 2007 03:14 GMT | 1 |
Cells E3, I3, J3, and K3 are ideally formatted as percent for ease of
interpretation by users, however this creates a difficulty with the value of
K3 seen as "1" in the VBA code.
Even though for example by comparrisson the value of E3 on the spread sheet
|
| Clone Sheet? | 15 Dec 2007 23:12 GMT | 1 |
Dear Sir,
How can I open a new worksheet(as it is 3 at once by default) on the same
worksheet(say,sheet1)?
Sincerely yours,
|
| Formatting a single column | 15 Dec 2007 22:46 GMT | 6 |
I'm trying to format column C, from C6 down in a Worksheet, so that entries
are formatted as soon as they are entered. The data is entered as "a1" or
"b3" (without the quotes), and needs to be displayed as "A-1" or "B-3"
(again, without quotes). The following code converts the ...
|
| vlookup ? | 15 Dec 2007 21:13 GMT | 1 |
I need to know how to do a vlookup and then pull all the data under it in the
field that is the same as the lookup. ie i am looking up ford and in the
lookup range there is more than 1 ford in a row? so lookup range is
sheet1a2:ac1040. ford is in cells a407 thur a597. i need to ...
|
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage
Start New Thread