| Thread | Last Post | Replies |
|
| Edit a Literal or Integer | 20 Nov 2007 18:46 GMT | 3 |
Here's a toughfy? How does one edit the following to be the following by using a macro? Sheet1End = 13 Sheet1End = 18
|
| 2007 Help | 20 Nov 2007 18:43 GMT | 3 |
Hi The following bit of code has been working previously excel2003 Dim wks as worksheet Dim actWkbk As Workbook
|
| changing location of words either in word or excel | 20 Nov 2007 18:38 GMT | 1 |
I have a list of songs in doc format. They are written like this: artist - song song - artist I want to have the entire list in artist - song format. Is there a
|
| Sheet name from range | 20 Nov 2007 18:28 GMT | 1 |
I have a range address that contains the workbookName+SheetName. How do I extract the sheet name only? Certainly a trivial question... Thanks
|
| Programmatically Restart Excel | 20 Nov 2007 18:26 GMT | 5 |
When users change certain configuration options in my Excel add-in I need them to restart Excel to have them applied - for example, the user interface language. I can either information the user that they need to restart or close Excel and require them to restart it. What I ...
|
| Pictures.Insert not working correctly in excel 2008. | 20 Nov 2007 17:50 GMT | 1 |
This code doesnt work correctly in Excel 2008 but works in Excel 2003. Range("F32").Select ActiveSheet.Pictures.Insert("T:\Sym-enh\CO\logo.bmp").Select Picture gets on top of the sheet instead of cell F32.
|
| Copy sheet with >255 chars per cell | 20 Nov 2007 17:39 GMT | 4 |
Excels sheet copy feature is limited to copying the first 255 characters in a cell. Could a macro be used to copy the sheet along with characters 256+, and if so, how would it be written?
|
| ListBox Control | 20 Nov 2007 17:35 GMT | 2 |
Is there a way to turn off the ListBox_Change event? I have a Multi-Select ListBox and when a user selects a particular line I use the Change event to update other lines in the same ListBox. This of course fires off the Change event again for each line I toggle.
|
| opening worksheet | 20 Nov 2007 17:28 GMT | 4 |
Hi, I have a worksheet that contains a column of dates. If I double click to open, or use File-Open etc, the dates format ok. I want to open using vba, so I recorded a macro, but when I run the macro, some dates format ok, august dates, others format as usa, september dates.
|
| Corrupted sheet - What the cause? | 20 Nov 2007 17:16 GMT | 2 |
Hi, my Excel sheet got corrupted and lost its reference to a range- therefore my Vlookup did not work. After opening it in Open-repair mode all was fine (and I was told athat the reference to the range was repaired)
|
| Refreshing Pivot Tables | 20 Nov 2007 16:56 GMT | 1 |
I have a macro that I am trying to use on my own spreadsheet. The code is beow. My issue is that when the Inputbox appears, the cell range is incorrect. How can I change the default cell range?
|
| Filter using Mid | 20 Nov 2007 16:43 GMT | 2 |
I have been going around and aroung with this. I am trying to filter to the 6th digit of a string. My variables show the correct values when I step through this yet it does not fall into the call. Here is my code: Sub AddCAMLineItem()
|
| Chart Title Reverts Back To Previous Value | 20 Nov 2007 16:36 GMT | 3 |
I have a chart showing delivery performance for a truck carrier. The chart is updated by means of a program, which pulls in data based on what carrier has been selected in another tab. It all works fine except for one thing: the chart title, having been set by a line in the ...
|
| Help with nested IF statements | 20 Nov 2007 16:28 GMT | 2 |
Ok here is what i am neededing help with i have to write a nested IF formula that meets the following conditions, and after working on it for hours i have decided i need help. Companies are categorized according to their market capitalization.
|
| referencing Solver.xlam vs. Solver.xla - 2007 vs. 2003 | 20 Nov 2007 15:48 GMT | 3 |
Has anyone a solution to reference issues such as this: I was asked to create a tool using Solver for use by a co-worker & his department. They are all using Office 2003 while I am on Office 2007. My code must reference the 2007 solver add-in, Solver.xlam, while to run on
|