in
All Tags » Excel » vb » MICROSOFT (RSS)

Browse by Tags

  • How do I search between two Excel sheets?

    Hello, Please see the attached Excel sheet. I am trying to do the following: 1) For each value in 'Sheet1' column 'B', search 'Sheet2' column 'A' for an identical value. 2) If an identical value exists in 'Sheet2', place the value from 'Sheet2' column 'B'...
    Posted to Other (Forum) by microsoft on 04-19-2010

  • How do I remove all characters in a string before the first occurance of a certain word?

    Hi, Please see the attached example Excel sheet. In the 'B' column on the 'BEFORE' sheet, notice there is junk test placed before the word 'Summary'. I need a VB macro that removes the junk text from each cell so the end result is as shown in the 'AFTER' sheet. The range...
    Posted to Microsoft Programming (Forum) by microsoft on 04-19-2010

  • How do I change cells marked as #Name? to display as a string?

    Hi, I have a spreadsheet with a range of data I need to parse. Certain cells, as shown in the attached spreadsheet contain the value '#Name?'. The string(s) contained in the cells start with '=' sign. Is there VB code I can use to append/change these cells so the string contents display...
    Posted to Microsoft Programming (Forum) by microsoft on 04-11-2010

  • Setting Tab order for spreadsheets

    Hi, I am trying to set a tab order through a set of spreadsheets which all have the same cells to be accessed. I have found some code which has worked fine for one sheet but doesn't work when copied to other spreadsheets in the same workbook. Is there an easier way to cover all worksheets or if not...
    Posted to Excel (Forum) by microsoft on 03-31-2010

  • Excel to Send E-mail when a cell reaches a threshold

    HI Guys, I have got a code that will trigger an event in a cell (A1 in this case but I will edit it to suit my needs) that will e-mail me if that cell changes, what I would like is to get it to e-mail me only if the cell has a certain criteria in it. This is not the main code but I would like to incorporate...
    Posted to Excel (Forum) by microsoft on 03-08-2010

  • Combining the IF and Range functions

    Following on from a previous question #23367661. Two parts to this question: 1) I would like to use the If and Range functions with mulitiple ranges to return differet results. E.g: In excell if I write: =if(a1:c1>d1,a2:c2,0) It will return the value in row 2 of the column that is >d1 in row 1...
    Posted to Visual Basic.NET (Forum) by microsoft on 11-02-2009

  • Excel Macro to Save A Worksheet as Text File

    Basically, I have a workbook with 4 sheets and would like to have a macro that saves one of the worksheets as a tab/semicolon delimited text file to a specified location once the workbook is exited. (BeforeClose event) I have been messing with the code for this and can't seem to figure it out without...
    Posted to Excel (Forum) by microsoft on 08-09-2009

  • Worksheet_SelectionChange + changing a cell color when text value changes.

    Hi guys, this is what I have. Private Sub Worksheet_SelectionChange(ByVal Target As Range) Target.Borders.ColorIndex = 5 End Sub The problem that I run into is the cell box is changing when I click on the cell box. I need the cell box not to change color if someone clicks around the excel spreadsheet...
    Posted to Excel (Forum) by microsoft on 06-14-2009
Page 1 of 1 (8 items)