| Thread | Last Post | Replies |
|
| how to add | 18 Jan 2008 01:50 GMT | 1 |
I have a question on this userform. It now loads nicely. Thanks. Is there a way to add a choice called all to the end of the list? That way the user can select which name to print or select all. In the case of all
|
| How come VBA if clause fails? | 18 Jan 2008 01:44 GMT | 6 |
I have the following subroutine. Why can't I see the passed-in Range's Cells(x,y).Value? Sub getDataInfo2(sRange As Range) Const maxr = 15
|
| Count Sum Problem | 18 Jan 2008 01:18 GMT | 2 |
Long time reader, first time poster. Hope I can find some insights. Using the following sample table I want to be able to count the number of times, and when, a total of 40 is reached in the Qty column. And then with the remaining amount begin the count to 40 again. For
|
| Addin Issues | 18 Jan 2008 01:01 GMT | 8 |
I've gone through all the forum postings from across the internet and have managed to piece this much together, but there are some issues that are inconsistently popping up still... What i'm attempting to create is an add-in for the department with
|
| format cells so they do not resize | 18 Jan 2008 00:54 GMT | 1 |
I created a order form and I do not want sales as they are typing to have the cells or form expand. Freeze the cells at teh exact size they are now if the test is longer they will have to put in a different info. Example
|
| Getting Chart "Cursor" information in Excel 2003 | 18 Jan 2008 00:47 GMT | 4 |
I thought I posted something along these lines yesterday, but .... What I would like is for the user to hold the mouse over a point in a series on a chart, and somehow signal me (Event) so I can find the corresponding row in the series. If I could get the information in the ...
|
| Protection on a sheet type thats new to me! | 18 Jan 2008 00:29 GMT | 2 |
On a sheetI came accross a form of protection that is new to me. It's not the normal cell protection- I have unprotected the sheet. I can see grid lines / scroll bar etc. I can see the row numbers- but it won't let me click on a cell!?
|
| Converstion of Complex Word VBA macro to Excel Macro | 18 Jan 2008 00:21 GMT | 1 |
I'm looking for someone who is familiar with Word and Excel to convert a very complex Word VBA macro to be able to function in Excel.
|
| default fill color | 18 Jan 2008 00:19 GMT | 5 |
is there a way to change teh default fill color for highlighting from the default yellow to say teh light gray color so when they come in they are easily able to highlight?
|
| Cell Content | 17 Jan 2008 23:51 GMT | 5 |
I am trying to use a Macro to sort through a table of numeric values and modify the values based on a series of If statements. Can someone tell me if the contents of a cell can be modified with a Macro, other than simple Copy/Cut/Paste funstion?
|
| Pivot tables - how to hide the total row? | 17 Jan 2008 23:50 GMT | 3 |
I setup a pivot table programmatic. But how can I hide the most right total row? I have found a checkbox "Totals for rows / columns" in the TableOptions Dialog.
|
| Linking rows on multiple worksheets | 17 Jan 2008 23:15 GMT | 1 |
I have a database that uses multipe worksheets to store data entered from a userform I created. On each worksheet the first 4 columns are the same but the rest are different, what I want to know is if it is possible to make it so that if I were to move a row in worksheet 1 from ...
|
| New user and need help | 17 Jan 2008 23:02 GMT | 1 |
Here is what I need to do I have been working on a sales sheet that will track the sales via a won loss ratio. Now what I have been trying to do is to take all of the information from the "activity" sheet and copy or perfer move it to a sheet based as "lost" or "Won" drop down ...
|
| UDF and dynamic range | 17 Jan 2008 22:01 GMT | 2 |
I have a function I built in which a couple of the inputs require a range... I would like to have that range be dynamic so that sometimes it select 4 dates or sometimes only 3... So I tried to put this in for my function (I16:OFFSET($I$16,H15-1,0))... but that doesn't work. If ...
|
| Skipping empty cells for a Range object? | 17 Jan 2008 22:00 GMT | 1 |
In VBA.. Is it possible to set a Range object to skip empty cels? IOW, if I copy A1:A10, and A5 is empty, and transpose them on B20, I want to skip A5; I did SkipBlanks:=True and it still pasted the blank cells.
|