| Thread | Last Post | Replies |
|
| protecting macro code | 26 Jan 2006 02:23 GMT | 2 |
Yes, I know that this is a subject frecuently asked, in fact, i want to ask something related to a previous post from http://groups.google.com/group/microsoft.public.excel ...
|
| Generating Hex key/password | 26 Jan 2006 02:07 GMT | 1 |
anyone have any links to sites regarding generation of random passwords (upper / lower case, numbers & symbols) - will use to generate keys for use in encryption. an added bonus would be some base64 / hex converters etc.
|
| how to set up master page that will auto update smaller pages | 26 Jan 2006 01:22 GMT | 1 |
i am trying to set up a tracking program that will enable my platoon to type in all students into a data base, then everyrtime we update the master copy, it will also save under each individual company. would it be better to use an access database vs. excel. it also has to be ...
|
| assign a unique number | 26 Jan 2006 00:56 GMT | 2 |
I have a database working fine. Data get input through a form. I like to fine if there is a way I can make the form or any additional code to give the new data row a unique number. Please help. Thank you
|
| Sum Data in Col B, Add % of Total Col C, Add Rolling % of Total Co | 26 Jan 2006 00:48 GMT | 2 |
Another challenge for a noob like me: I start out with this, with the headers at Row 6: Security Value Apples 10
|
| New object/automation error | 26 Jan 2006 00:11 GMT | 2 |
I need to create a new sheet in my macro. So far the code I've been using looks something like this: Dim sheet7 as worksheet sheet7 = new worksheet
|
| Is it possible to edit multiple pivots at one time? | 26 Jan 2006 00:08 GMT | 4 |
Say I have 5 pivot tables that all have in the drop down menu "Geography" in A4. I would like to know if excel has a capability to select say Americas from the drop down box and the same be selected and updated for every pivot you have within the file. I thought perhaps my ...
|
| Question on a Chip Pearson macro | 26 Jan 2006 00:07 GMT | 4 |
All - It is with no little temerity that I post this question about a Chip Pearson macro found at: http://www.cpearson.com/excel/deleting.htm
|
| Userforms | 25 Jan 2006 23:44 GMT | 1 |
Is there a way to get one userform to pop-up and another one to pop-up in front of it in one action.
|
| Nestling of functions | 25 Jan 2006 23:40 GMT | 5 |
I want to insert a certain number of row texts into 20 identical spreadsheets. When I copy the area I want to insert then my macro stops after the first of the 20 sheets. I use "for x=1 to 20" "Next x" to acheive the repeated copy.
|
| Run-time error 1004 | 25 Jan 2006 22:29 GMT | 1 |
I use a macro to save an XLS workbook (created from an XLT template) to HTML format for our intranet. It works fine once, but the second time it opens the saved HTML file before running the macro, which causes the error: Run-time error '1004': You cannot save this workbook with ...
|
| referencing a cell within a header | 25 Jan 2006 22:24 GMT | 1 |
Is there a way to reference a cell's value in a header? I have a time card that within the header is a pay ending from and to date that I must manually fill out (argh!). Since the information is already in the spreadsheet every week,[ always B5 and F5 ] I would like to be able to ...
|
| Find Range for Pasting of Records | 25 Jan 2006 21:58 GMT | 1 |
I am pasting data into inserted columns. How do I figure out the range of the records that I have so I know when to stop pasting down the new inserted columns? A B C D E
|
| setting where cursor is | 25 Jan 2006 21:48 GMT | 2 |
hello: what code would I need to add in my macro that records where the cursor is (eg-cell A14) when the macro button is pushed and then return to that spot (A14 in this example) at the end of the macro.
|
| German VBA Problem | 25 Jan 2006 21:48 GMT | 3 |
I have a problem with a German VB file which I am sure is related to the time and date format used in the UK dd.mm.yyyy If i sent my PC to location Germany then the code works. Can any help, here is the code
|