| Thread | Last Post | Replies |
|
| Question about Functions | 27 Feb 2008 15:15 GMT | 3 |
A B C D E F G 105 92 DEARHOLT JOSEPH E5 1/11/2008 GMT Yes 106 93 DELACERDA EDGAR E7 1/11/2008 GMT Yes
|
| Excel Sort? | 27 Feb 2008 14:59 GMT | 3 |
Below is a sample of the portion of a column on an excel sheet. I would like to put everything to the right of the number in a separate column. such as, everything to the right of 6346, 6510 and so forth and trickier
|
| Excel 2002: Can I save all the flies in the window at one go ? | 27 Feb 2008 14:32 GMT | 2 |
Dear Sir, Let say I open 12 files in a window and update all of them simultaneously, after that I need to save all the files to quit this session and to proceed with another session.
|
| Return value in "Sub" | 27 Feb 2008 13:54 GMT | 5 |
I was trying to figure out how to return a value from a "Sub" procedure. I understand that if you write a function you can set a value equal to that function and that will return the value. For example Public Function TestFunction(iVal as integer)
|
| Printing problem | 27 Feb 2008 13:54 GMT | 1 |
How do I make sure that my report will print within the margins on every page. I have an Excel file and will be email if so requested. Please help, thanks
|
| cannot shift items off sheet-published fixes don't work for me | 27 Feb 2008 13:53 GMT | 1 |
I get the above error message when trying to insert a new row into my spreadsheet. I have reviewed many posts concerning this problem, but none of the solutions has worked for me. I am using Excel 2007. I deleted the blank rows below and blank columns to the right of my data. ...
|
| How to specify location for chart in VBA | 27 Feb 2008 13:50 GMT | 1 |
I'm adding a chart to an existing spreadsheet with the following: ActiveChart.Location Where:=xlLocationAsObject, Name:="IPS" However, it's leaving too much which space between the bottom of the existing data, and the start of the chart.
|
| How to split wrapped text in a single cell into multiple lines | 27 Feb 2008 13:30 GMT | 2 |
I really need help on "How to split wrapped text in a single cell into multiple lines" e.g Text (wrapped) appear in one cell Prepare and allow "Rentokil" anti termite treatment as described to sides
|
| Use auto filter in a protected worksheet | 27 Feb 2008 12:47 GMT | 4 |
I am using excel 2007, I set up the auto filter and it works fine. I protect the worksheet and I selected the "Use auto filter" option. Then the auto filter does not work. What am I doing wrong?
|
| current worksheet | 27 Feb 2008 09:36 GMT | 1 |
Hi How do i use VB code to find name of current worksheet. I run same macro from different sheets to copy data to another. I want the code to figure out the current worksheet and make reference to this sheet in a paste area
|
| How do I slant the column headers so they are more readable? | 27 Feb 2008 08:28 GMT | 4 |
I've seen docs where the column headers are slanted, and the text is vertical, but not completely vertical. I can't find how to create those, or if it can even be done in Excel or Word. Am I painting a clear enough picture of what I mean?
|
| Multiple Data Validation Checks | 27 Feb 2008 06:02 GMT | 3 |
I want to restrict a user for input of numbers only between 1000 to 9999 except for some 4-digit numbers listed in a range named "WRONG"! Any idea how to put a Data Validation check by custom or any other option? Thanx!
|
| VB Code to hide and unhide rows | 27 Feb 2008 05:58 GMT | 2 |
I need a VB code for the following. When I select a range in an excel sheet. The hidden rows in that range should get unhidden and then based on a condition the rows must be hidden within the selected range.
|
| need urgent help on macro merging | 27 Feb 2008 05:07 GMT | 3 |
The following macro merges correctly entries which jhave more than one row ,,, but when only one entry per name is available then it merges along with it the next row also. can any1 pls tell me where i have to correct Dim e As Integer
|
| Automatically Adding Time based on a name ranged | 27 Feb 2008 02:13 GMT | 1 |
I have a named range --- 178 1:45 5969 2:00 48 1:30
|