|
|
Copy Outlines in Excel 2007 by
alexd
Hi,
Anyone know if it's possible to copy Outlines (the groupings, not the data)
from one worksheet, or workbook, to another?
Thanks
|
December 10th, 2008 02:10 PM
by alexd
|
0 |
90 |
|
|
auto open a workbook by
Jase
Is their a way that when I open an xls workbook that I could write some code
under the workbook_open sub that would automatically open a csv workbook and...
|
December 10th, 2008 02:05 PM
by Jase
|
0 |
110 |
|
|
Cell reference in Square Brackets by
Nev
Hi there
Hope you can help. I want to be able to put a variable in .
As an example =si!e9. Therefore wahtever the work book name in a6,a7,a8
etc will...
|
December 10th, 2008 01:20 PM
by Pete_UK
|
5 |
82 |
|
|
F.A.O Mike H by
leerem
Hi Mike,
You gave me the code as attached below for listing the
contents of a folder:
Private Sub Worksheet_Activate()
ListBox1.Clear
MyPath...
|
December 10th, 2008 01:20 PM
by Mike H
|
3 |
93 |
|
|
unprotect worksheet when...... by
Wanna Learn
Hello is it possible to unprotect a worksheet when a certain cell is
selected using VBA . I need to unprotect the worksheet when cell B34 is
selected and...
|
December 10th, 2008 01:14 PM
by leerem
|
1 |
104 |
|
|
Data Validation List Not Working Correctly by
Mike D
I'm trying to validate data that is being entered into a cell based on a
list that is on another worksheet in the same workbook. I have the range
with the...
|
December 10th, 2008 01:09 PM
by Mike D
|
6 |
166 |
|
|
Disable the save button by
leerem
Hi,
I need to be able to force the user to save the spreadsheet by use of
VBA as opposed to useing the save button or using the File\ save in excel...
|
December 10th, 2008 01:06 PM
by leerem
|
4 |
137 |
|
|
|
December 10th, 2008 12:34 PM
by Jim Rech
|
1 |
539 |
|
|
Folder Contents listed in Combo box by
leerem
Hi all,
As mentioned in the Subject line, How would I list the contents of
a Folder eg. D:\Any\Contacts\?????. and have this info displayed in a...
|
December 10th, 2008 12:32 PM
by Mike H
|
4 |
131 |
|
|
|
|
2 |
130 |
|
|
graph for Breake even point by
pol[_2_]
Dear all
Please anybody can help me with a sample graph which are using in business
for Break Even point analysis. It would be very helpful to me. Please...
|
December 10th, 2008 12:10 PM
by Max
|
1 |
168 |
|
|
Excel 2007 won't open Excel 2003 Files by
Tom Breck
I have purchased a new lap top running Vista with MS Office Enterprise
Edition. I am trying to work with files created on a desk top system running
Windows...
|
December 10th, 2008 11:57 AM
by Jim Rech
|
1 |
181 |
|
|
|
|
4 |
92 |
|
|
COUNT IF - 2 conditions by
Darrren
2 columns.
column 1 needs to be searched for a certain numerical value (a 6 digit code)
column 2 is a series of numbers and needs to be searched for a value...
|
December 10th, 2008 10:50 AM
by Darrren
|
4 |
100 |
|
|
Counting Days between Accidents by
aussiegirlone
Dear T. valko
I am sorry for not responding sooner as it just became too much for my
little mind to cope with changing all my formula’s to get the one I...
|
|
4 |
104 |
|
|
Saving Excel to Text file by
BIGGByran
I want to save an excel sheet to a text file, but I don't have the columns to
be tab. I would like it to have no spaces between columns. Ex
Name Col; ...
|
December 10th, 2008 09:37 AM
by Pete_UK
|
1 |
90 |
|
|
Changine text into a date by
Crauwf
I have the following date 20081128
How do I convert this figure to the date 28/11/2008?
Can anyone help?
Thanks.
|
December 10th, 2008 08:39 AM
by Crauwf
|
8 |
107 |
|
|
dates in excel? by
Nevermind
If in one cell I enter date 12.6.2008., I need that the cell next to
automaticly calculate date which is 60 days from that date (in this case it
would be ...
|
|
2 |
102 |
|
|
|
December 10th, 2008 08:23 AM
by OssieMac
|
2 |
118 |
|
|
autofill colour based on date entry by
Tacrier
I have a spreadsheet to record when monthly duty reports are received by each
employee and reviewed by mgmt.
Column A1:A200 Employee Name
Column B1:B200 Date...
|
|
9 |
230 |