Programming

Via code, making 2 named Ranges Indentical, upon change
Hi, Here is a good one I have been pondering for a while, still, in all my efforts, I have not gotten what I really need. I am not an Excel-VBA expert, so I am hoping somebody in here can give some insite. OK, unforunately, there is no row insert/delete event..WISH LIST I have 2 seperate named ranges; if I... 24 Jul 2008 03:40

Please help me finish this simple macro
Hello, Everyone! I am trying to convert text dates to real dates. I need to find all yellow cells in range B4:B100, strip off the offending text (i.e. Sat. or Thurs), and use DateValue to turn the rest (which looks like 1/05/2007, but sometimes 1/05/07) into a proper, numerical date in the ddd mm/dd/yy format... 21 Jul 2008 04:51

WM_GETTEXT WM_SENDTEXT - HELP ALL OF US UNDERSTAND THIS!!!
Programmers, I'm calling out an SOS... WM_GETTEXT or WM_SENDTEXT has to be most unexplained thing on the internet. I have spent over 3 hours trying to search for a newbies guide to using this santax in my programs but I have been very unsuccesful -- I did however learn how to reveal a saved password that is h... 26 Jul 2008 20:11

Error Using the PivotFilters function
hi to all! I'm just new in pivottable programming in excel. I can't get to work the PivotFilters function, the statement is written as: shtWorksheet.PivotTables(1).PivotFields(23).PivotFilters.Add Type: =xlValueIsBetween, Value1:="101" running this statement causes me an error saying: Runtime error 1004, ... 21 Jul 2008 05:52

Wrong columns sometimes selected -->?
I am running Excel 2007 on Vista and have experienced a strange problem. . . . What I am doing is finding CSV files in a directory hierarchy, modifying their format, adding a couple of charts, and saving them as Excel (.xls) files. The input (CSV) files all have a standard format (produced by the same software... 21 Jul 2008 21:19

finding last space in a text function
I want to locate the last space in a text string, so that i may reproduce the string without the characters which occur after the space. Foe example if i have "Hydrochloric acid 1M" as the string, i would like to produce "Hydrochloric acid" from this. The text string can vary in length as can the final tex... 21 Jul 2008 04:51

Shift constant values in a range left or right by n columns
Hi, Excel folks - Given a range containing some cells with constant values and some cells with formulas, what is the most efficient way to shift only the constant values left or right by a specified number of columns, leaving formulas and all formatting in source and target cells unchanged? I'd also want to c... 21 Jul 2008 15:08

Splitting Data to new workbooks
I regularly need to split a report held in a single worksheet into new separate workbooks and I use the code below which I have modified from one I found on the exceltips website. My problem is I ofen need to split by a column other than A. For example columns A-C would be "Business", "Region", "Team" and I n... 23 Jul 2008 19:29

using & function
I want to transpose two cells into one whereby I have a text vaue "text" and a percentage - eg 50%. In the adjacent cell i want to produce text&" "&50%, to come out as text 50%. However but it comes out as text 0.5 Is there a way to make excel display exactly what i want rather than it converting the percentag... 20 Jul 2008 20:41

fileformat property compatibility
Hi, I need to distribute an Excel app (with VBA) to users with versions of Excel ranging from Excel 2000 to Excel 2007. The app has to be able to save workbooks in a common format (so something saved in Excel 2000 can be read in 2007 and vice versa. The files must also be able to handle unicode. I tried this: ... 22 Jul 2008 23:59