|
Label positions
On an Excel 2003 spreadsheet which is much wider than any screen it is
inconvenient if cell labels do not stick in the position they are left. I
am finding that when I reopen the spreadsheet the labels may have moved
horizontally to the left hand side of the spreadsheet (not the LH side of
the screen but go to the screen which starts column A.
It is tedious to manually move these ba...
|
7 |
18.09.2006 12:40:13 |
|
|
Other data bases?
Hello!
I am a Vba/Excel fanatic and have made several succesful applications. I was
wondering, however, how can I use VBA with other data bases such as MySQL?
What is the procedure for migrating to other data bases? Could you give me
some advice for using a succesful application with a database that is about
to reach the 65536 row limit?
I thank you in advance,
Albert...
|
2 |
18.09.2006 10:47:19 |
|
|
FOrmula Help Please, Im so confused
I have a formula that outs out net margin which is
=(Margins!$C$6-MIN-'TMobile 18 Costs'!D5)
I also have another formaula that turns negative into positive If a
positive states "FOC" if negative adds VAT and rounds up to nearest
9.99.
=IF(C8>=0,"FOC",CEILING(-C8*1.175,10)-0.01)
So if a neative was -89 turns it into +89 *1.175 = 105 then changes it
to 109.99 automatically
With...
|
2 |
18.09.2006 10:46:02 |
|
|
limit on size of macro for excell97
Hi
Does anyone know if there is a limit on the size of a macro in Excel 97.
The reason i ask is that when i get to a certain point in writing a
macro, excel bombs when i try to load the spread sheet containing the
macro. If i just paste the macro in from a copy i made in word, excel
works fine. It's only when i try to load the spread sheet that i get an
error which causes excel to close...
|
2 |
18.09.2006 03:49:52 |
|
|
advanced filter
here is the file: http://www.mytempdir.com/935740
First sorry for my english....
I have this code to insert letter "E" in column N of a sheet GAF only
if the
dates in column B of sheet GAF are into range DATAIN/DATAFIN
use for test DATAIN=01/11/2005 DATAFIN =30/11/2005)
Now, i want to use the same code to insert "E" in column N if the range
of
dates is naturally into range DATAIN/D...
|
2 |
18.09.2006 03:49:34 |
|
|
macro that strips data from string
Hi,
I am new to VBA & Macros. Appreciate any help I can get. I have a macro that
strip's data from a string and it works fine except I need it to strip
further in the string. example of results:
bunder_linn-S1/0-720L-140.55.135.34-NIPR-1.5M(In)
What I need is to strip from the second - to the (
example: bunder_linn-S1/0-720L-140.55.135.34-NIPR-1.5M(In)
It can strip and copy to cl...
|
6 |
18.09.2006 00:35:51 |
|
|
FOrmula to work out pricing rounding up and down
I have a formula in cell that reads "=IF(C7>0,"FOC",-C7*1.175)" it
turns a negative into a Positive and a Positive FIgure into answer of
"FOC" Sometimes it will display a result of £2 or £5.50 or whatever
the figure when the original answer is a negative.
With me so far!!
The result which is displayed as a number i need it to round up t the
nearest 9.99.
For example
if c7 is £4....
|
4 |
17.09.2006 21:11:02 |
|
|
Pasting Formulas bug?
I seem to be having a strange problem with my Excel (11.2.5) for Mac.
I have pasted formulas for years and never had an issue...until now.
The formulas are simple (addition, subtraction, etc.). I copy the
formula in a cell and paste it to a new one (I even do this with Paste
Special...Formula). What appears in the spreadsheet is the value of
the original cell, not the result of the "relativ...
|
4 |
17.09.2006 16:53:36 |
|
|
Insert Function Wizard agrument descriptions.
I have written several functions in VBA, then saved the sheet as an .xla
which I use as an add-in. The functions appear in the Insert Function
Wizard, as expected - almost. I have not found a way to display the
arguments' descriptive text. I know this is available in in .XLL's through
a call to xlfRegister, but how does one accomplish this through VBA?...
|
2 |
17.09.2006 16:10:38 |
|
|
Protection controlled by macro
I have a worksheet that is password protected. I want to create a
macro that will unprotect the worksheet, perform several operations,
and then reprotect the worksheet using the same password.
I have tried including the password within the macro to unprotect and
reprotect the worksheet, but I still get prompted for the password when
the macro runs.
Does anyone have any suggestions on ho...
|
5 |
17.09.2006 16:03:59 |
|
|
cannot open excel files after upgrading
I have office xp. after upgrading to sp2, sp3, I cannot open old excel
files. massage "this file is not in recognizable format".
help!!!
thanks
y.r.i
...
|
1 |
17.09.2006 14:10:35 |
|
|
Problem with Security Level
I have an Excel Application which I have written for other employees to
use. I have disabled the icons on the tool bar to prevent any changes
to the application.
The macro security level on one computer keeps reseting itself to High
preventing macros from working. I reset the security level to low and
save it. When it is opened again, it has reset itself to High again.
This application ...
|
1 |
17.09.2006 13:14:24 |
|
|
Copying data from Excel to Word
How can one copy the contents of cells in Excel to a Word document? Can you
use a cut-and-paste method?
Thanks,
Bob on Jeff's computer
...
|
2 |
17.09.2006 12:52:01 |
|
|
Displaying Time In Decimal Formats
I created a spreadsheet for making schedules, and am attempting to force
time to display in hours (as in 7.5 hours), instead of normal time
(7:30). I can't find a decent way of displaying it properly. Here's how
I have it set up currently:
B5: Start_Time
C5: End_Time
B6: =IF(C5-B5>0.166666666666667;C5-B5-0.0208333333333333;C5-B5)
The formula in B6 just checks to see if the scheduled sh...
|
5 |
17.09.2006 05:45:12 |
|
|
Is there a way to use VBA to set up a VBA password in another workbook?
Hi everyone,
Is there a way to use VBA to set up a VBA password in another workbook?
I know there is way to put VBA module and sub procedure into another
workbook using VBA, but can I password protect them using VBA as well?
AS
...
|
3 |
17.09.2006 05:24:52 |
|
|
Editing cell and showing value
My problem is editing inside a cell that contains a nested if formula.
After editing the cell and pressing return the cell places the 'formula' and
not the 'value resulting from the formula' in the cell. I keep checking if
it is protected but to no avail. Does anyone have any thioughts on this?
Thanks in advance.
John
...
|
2 |
17.09.2006 02:26:43 |
|
|
How To Determine if Your In 1 of the last n rows
Dear NGs,
Good morning. I want to use an IF statement to set a cell value to
"True" or "False" based on the following condition: If in 1 of the last
200 rows of the spreadsheet then TRUE, else FALSE. I have found posts
that describe how to get the last value in a column using a number of
functions including the Index, Lookup, Isblank, and so on, but I've not
found any that address this s...
|
3 |
17.09.2006 00:45:58 |
|
|
READ BEFORE INSTALLING OFFICE 2007 B2TR
The B2TR patch has some nasty surprises for users in store. The most
important one being that Word 2007 Beta 2 files saved in the new file
formats (extensions docx, docm, etc) might not open at all once B2TR has
been installed.
Excel files in the file formats (extensions xlsx, xlsm, etc) saved in B2
should open in B2TR. PowerPoint files saved in B2 in the new file
formats (extensions pp...
|
18 |
16.09.2006 20:34:35 |
|
|
Can't get rid of combo box
Hi,
I followed these instructions from a previous post, but it didn't help.
Edit>Go To, click Special
Select Objects, click OK
Press the Delete key, to delete any objects that were selected. (no
objects were selected)
If that didn't work, it may be an object from the control toolbox:
(yes, it was)
Choose View>Toolsbars>Control toolbox
Click the Design mode button
Point to ...
|
4 |
16.09.2006 18:36:09 |
|
|
Locking Cells - Unconditionally, No "Protect"?
Is there any way to make cells totally, completely unchangeable without invoking
the "Protect Sheet" functionality?
I'm creating an Excel sheet that will be used as a data entry template and one
of the columns contains record ID numbers from a database which, if changed by
the user, will break the application that has to read the sheet.
Or should I just bite the bullet and use "Protect Sh...
|
4 |
16.09.2006 14:31:01 |
|
|
How do you Reset a Combo Box
Hi
I have a few No/Yes Drop down option in Excel
They all default to No unless user changes it to Yes.
What I am after is a reset button to change it back to No
Thanks
Paul
...
|
3 |
16.09.2006 11:28:09 |
|
|
Coloring cell text based on value
I have a cell with the following formula:
=SUM(E11:E49)
What I would like to do is have the result display in red if the the
value is over 2000 and to display in blue if the value is less than or
equal to 2000.
Thanks for the help. :)
--
Zilbandy - Tucson, Arizona USA <zil@zilbandy.com.invalid>
Dead Suburban's Home Page: http://zilbandy.com/suburb/
PGP Public Key: http://zilb...
|
4 |
16.09.2006 08:19:05 |
|
|
Splitting an excel file into two columns
I was able to import my text files into a spreadsheet, but here is what
I need to do next and I hope there is an easier way to do this through
the program. Her is what I have, I have a product spreadsheet that
includes item number followed by the description. the item number is
always first and needs to be broken out into its own column with the
description in the next.
What I am wanting...
|
3 |
16.09.2006 04:23:26 |
|
|
Displaying Multiple Excel files, Not plotting zero values
Hello,
I have two questions:
1) How ccan I display more than one Excel workbook in different window? When
I open more than one Excel workbook, I want to display them side by side to
make some comparisons. When I open one other closes. Is there a way to open
many Excel windows?
2) I have a data set with lots of zero values. I use scatter plot. I want to
only display non-zero va...
|
2 |
16.09.2006 02:40:39 |
|
|
Move multiple cells at once?
Does anyone know how to move non continuous cells at once in either 2003 or
2007 beta 2? For example A1 & C1?
Thanks
Jim
...
|
3 |
15.09.2006 22:19:31 |