| Thread | Last Post | Replies |
|
| Problem with code - Help | 29 Jan 2008 13:39 GMT | 8 |
I have been using the code below with no problem and have just moved it to a new module and now it wont work ?? Any suggestions welcome, i am not a programmer but a dabbler & just cannot find the problem.
|
| Rosh Hashanah and Yom Kippur Holiday Dates Revisited | 29 Jan 2008 12:38 GMT | 1 |
Ron Rosenfeld, I found the following code that works up until I enter the Gregorian year 2024 (fiscal year), molad 5784, then it shows Rosh Hashanah beginning sundown of 9/16/2023 and ending 9/18/2023 with Yom Kippur on 9/25/2023. The calendar
|
| How to see value of UDT variable while single-stepping? | 29 Jan 2008 11:36 GMT | 1 |
At an LSET statement (for example), how can I see the value of each element of a user-defined-typed variable on the right-hand side? For VBA types, I can simply hover the cursor over the variable name. That does not seem to work for UDT variables.
|
| Macro Properties Password Popup. | 29 Jan 2008 10:16 GMT | 1 |
I have modified Normal.dot to add classification macro in it. The code for this macro has been locked and password protected. In normal operations using just MS Word there is no problem at all. But when users try to open word files stored on SharePoint Services 3.0 … macro ...
|
| sorting in multiple sheets | 29 Jan 2008 09:16 GMT | 2 |
Hi Tom, i have multiple sheets from A to Z and i need to sort column L i used this code
|
| Userform TabStrip questions | 29 Jan 2008 07:20 GMT | 2 |
I am trying to design a form and I am using a TabStrip. Depending on what my code determines I would like to set the number of tabs in the code. Is it possible to Enable / Make visible a single tab on a TabStrip? Is it possible to add or remove a single tab on a TabStrip?
|
| "Object required" error | 29 Jan 2008 05:49 GMT | 1 |
Why does this produce an "Object Required" error and how can I fix it? Column A contains worksheet names. Row 5 contains text representing a cell reference like "G16". ==================
|
| Anyone know how to program transfer of CSV data to web page form fields? | 29 Jan 2008 05:08 GMT | 2 |
How can you populate a form fields on a html web page (client side) with data from an Excel file (CSV). The web page has several text fields for input that I manually populate. I would like to transfer the data into the web form automatically from the CSV file. How can
|
| creating a macro to add text to existing data already in cell | 29 Jan 2008 04:11 GMT | 6 |
Forgive me, I am new at Excel macros. I have a spreadsheet with thousands of cells that now require extra text be added to the existing data already in the cell. The extra text is the same for all cells involved. I tried creating my own macro using record, doing the steps,
|
| What is planned to replace VBA? | 29 Jan 2008 03:58 GMT | 8 |
I know that VBA is still alive in Office 2007 and is reportedly (depending upon which report you read) going to be supported for awhile. I love VBA, but apparently VBA is going to be phased out. My feeling is that it is best to get ahead of the game, welcome the change (and ...
|
| User selection from a chart | 29 Jan 2008 03:52 GMT | 1 |
I have a VB app that uses a VBA script to create a sheet with data and then another sheet with a chart representing that data in graphical form. The sheet with the data on it has formulas that are run on a subset of the data. Currently these formulas are hardcoded with the ...
|
| Sort all worksheet contents with a macro | 29 Jan 2008 03:32 GMT | 3 |
I have searched the boards and have not found what I need. Hoping you can help. I am using the following to sort worksheet order within a workbook and it is working perfectly. http://www.cpearson.com/excel/sortws.htm
|
| How to prevent Excel to paste data in separate cells | 29 Jan 2008 02:53 GMT | 2 |
I dont know why this is happening sometimes. We have a database (created from COBOL?) where I usually copy a payment history screen onto Excel for when I need to create a report. Sometimes when I capture the data such as this from the Cobol DB:
|
| Speeding up slow code | 29 Jan 2008 02:50 GMT | 4 |
I work in an accounting firm and for audits we sometimes get general ledger documents in Excel that we then process to see if there are interesting patterns, etc. The problem is that most of the time, these are basically puked into Excel
|
| Value not shown on selected ActiveCell | 29 Jan 2008 02:00 GMT | 1 |
I have the following code attached to a macro. The macro is associated to a command button. When the command button is clicked, this macro will ve invoked and the display/place the result into ActiveCell. Problem I have is that the macro knows which is the active cell but ...
|