Programming

Extracting a number from a multiline-entry
Dear Experts: I would like to extract a number from multi-line excel cells. The cells have the following make-up 123456(manual line break = Alt+Enter) sample text (manual line break = Alt+Enter) sample text In the above example I would like to extract the number located immediately before the first manua... 25 Mar 2010 13:50

How to set cell validation in excel using name range?
I have 2 worksheets in my workbook. First worksheet has name range (for example a1:b5 name = valName). In another worksheet I want to create cell validation as combobox by using value from range name "valName" in first worksheet as it source. How can I do that in C#? ... 22 Mar 2010 04:59

move one cell down
Hi, I need to make a macro who can move one cell down from the active cell and make this cell active. ex: active cell = C1 => new active cell C2. I hope some of your hard guys can help me with this problem. ... 22 Mar 2010 02:47

User Form Date Field disappeared!
I have an Excel workbook that I have been using for 6-7 years, initially in Excel 2003; and more recently in Excel 2007 (where it is saved as an .xlsm file). There is a user form to enter data, and one of the pieces of data is a Date. I could either enter the date directly, or select the different sections (M/D/... 23 Mar 2010 10:09

Extracting data from an excel spreadsheet
Please can anyone help with me with some VBA Coding for an excel spreadsheet. I need to extract the year 2010 data from a master file copy it to a new spreadsheet, and need to keep it linked. They have set up the spreadsheet with blank rows and also wants to keep the all the formatting. Paste linking does... 21 Mar 2010 21:59

Pick numbers
Hi, If I have a string of numbers, for example 51900125 and I want to pick number three (in this example 9) in a specified cell, what shall i type. I have tried Left and right but then I got a string of figures. Do anuone know how to solve this? -- Best regards Mia ... 21 Mar 2010 12:44

String of numbers
Hi, I have a problem to make a string of numbers. What I'm trying to do is following. Ex. 1 Cell A1 45-0001 Cell B1 5975 The result I want in Cell C1: 450001005975 I'l be wery grateful for some help! -- Best regards Mia ... 21 Mar 2010 11:37

Replace manual line breaks (Alt+Enter) with two spaces for selectedcells
The return in the cell is code as an ascii character Linefeed which is a 10. In the code below I set a variable to character 10. You can also use vblf. You can use any string method with the linefeed like REPLACE to remove the character or replace the character with other characters LF = Chr(10) or LF = vbLF ... 21 Mar 2010 17:22

Replace manual line breaks (Alt+Enter) with two spaces for selected cells
Dear Experts: For selected cells in a column, I would like to replace any line breaks (Alt + Enter) with two spaces using a macro solution. There are cells that have multiple line breaks! By the way: can this be achieved using the bulit-in search and replace functionality as well? Help is much appreciated.... 21 Mar 2010 17:22

Help with DDE - stock feed
Hey All, i am using excel 2007, i am not an expert at all with coding. i am trying to capture DDE stock feed and record every change in the price cell into a growing column. so assume the DDE link will be placed at cell A1 and i am trying to get the Excel recording every change into say Colume C which will ... 21 Mar 2010 08:18