Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / November 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Edit a Literal or Integer20 Nov 2007 18:46 GMT3
Here's a toughfy? How does one edit the following to be the following by
using a macro?
Sheet1End = 13
Sheet1End = 18
2007 Help20 Nov 2007 18:43 GMT3
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 excel20 Nov 2007 18:38 GMT1
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 range20 Nov 2007 18:28 GMT1
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 Excel20 Nov 2007 18:26 GMT5
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 GMT1
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 cell20 Nov 2007 17:39 GMT4
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 Control20 Nov 2007 17:35 GMT2
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 worksheet20 Nov 2007 17:28 GMT4
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 GMT2
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 Tables20 Nov 2007 16:56 GMT1
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 Mid20 Nov 2007 16:43 GMT2
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 Value20 Nov 2007 16:36 GMT3
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 statements20 Nov 2007 16:28 GMT2
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. 200320 Nov 2007 15:48 GMT3
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.