• VBA Help Needed: How Do you extract from a column a specific color?

    This is my code.Sub Looping() Dim matchFound As Boolean Dim thisIsTheYValue As Integer 'For x= 3 To 6306 'For y = 3 To 1971 For x = 3 To 6306 matchFound = False For y = 3 To 1000 If Cells(x, 4).Value = Cells(y, 9).Value Then ' this is the x column that was the same as the y column Cells(y,...

    rolando05315 pointsBadges:
  • Outlook email doesn’t send when computer is locked

    I've recently been having issues with sending Outlook emails using Excel VBA. I already have my code to do it, Sendupdate, and it's working fine when it's manually run. I also have an automatic timer that's intended to execute the same email at a specific time. But when the computer is locked, it...

    ITKE409,490 pointsBadges:
  • Cell Automated Population using Excel macro

    Hi, Is there a way in macro wherein if a certain cell has value, the other cells will be automatically populated? Example: In cell E6 I put the date, cell A6, B6,C6 and D6 will automatically copy the values in A4, B4, C4 and D4. Same goes when I enter the date on cell E7. Thank you so much in...

    Eron09135 pointsBadges:
  • VBA format a cell based on range contents

    I need to create a macro that goes in to a worksheet and looks at the contents of a range to see if it contains any number other than zero. If it does, I need it to turn a separate cell yellow. 'assign variables Dim rngSat As Range Dim rngSun As Range Dim wsOT As Worksheet Set wsOT = _...

    VbaNewb1315 pointsBadges:
  • VBA copying a range from Excel and pasting to a text file

    Do you know how to copy from excel and paste to a text file using VBA?

    TBone555 pointsBadges:
  • VBA Copy and Paste using dates

    I have a spreadsheet that I am compiling for completed work orders. The sheet I want to copy the information from is called "Completed". In column H, I have the date each work order was completed and the dates are formated mm/dd/yyyy. I would like to have a code that will copy the work orders that...

    Bbourque965 pointsBadges:
  • Convert iSeries Character set in VB

    I am creating a VBA macro in an Excel spreadsheet to download selected data from an iSeries database. Running into an issue with character set. I don't understand VB well enough yet and have not had success w/ google in resolving this. I appear to be getting the data, but a lot of the fields are...

    azohawk1,880 pointsBadges:
  • Is there any way to know on which date data was entered on a specific cell?

    Is there any way to know which date data was entered or changed on a specific cell?

    Dbrody5 pointsBadges:
  • How to change colors in Excel VBA

    I need to be able to change the fill color of a range of cells in the active cell’s row. When I pick another cell in another row the previous active row, it should revert to its original color.

    GrayBear5 pointsBadges:
  • Showing progress bar form during QueryTables

    Hi, I'd like to add a form on my VBA Excel showing a progress bar during data downloading or during other DB process. I'm using VBA QueryTables to download from an Oracle db, PivotTableWizard to download it on a pivot table and ADODB Execute to execute stored procedures. Thanks for your help.

    webluca60 pointsBadges:
  • how to create autonumber

    while press enter on cell (b1) the cell (a1)= 1 while press enter on cell (b2) the cell (a2)= 2 and so on i tried functions : =row() and =OFFSET(A2,-1,0)+1 i don't think its an autonumber because i used manualy so, hlp pls

    Army125 pointsBadges:
  • Excel 2003 Macros with Org Chart Parent

    Hello, I have a corporate org chart for which I am trying to write a macro. The Excel workbook is set up so that each company is in a unique cell. The subsidiary is one column to the right. For instance, I would like to return the values in the far right column for the data below. Thank you. COL  ...

    Vanillathunderrr5 pointsBadges:
  • Unlocking VBA project using VBA code

    Can i use vba code to unlock my x-cel vba project protected by password? I need to unprotect my project to add some code and then reprotect it.

    Yves69520 pointsBadges:
  • Excel VBA Count # of Cells within Max and Min in a Table

    How do you write a VBA macro that count the numbers cell within a selected table that falls between a maximum and minimum number?

    Haxel5 pointsBadges:
  • VBA Excel 2003 Copy and Paste

    I would like to know how am i going to copy a certain range (A1:E500) in File A and paste it in a different file (File B). Then copy a new range in other sheet of File A then paste it in File B without overlapping the data I copied from the first range. Thank you so much in advance!

    Eron09135 pointsBadges:
  • I need vba code to update item cost from a word document w/o changing the previous wks item cost in Excel 2004

    I have a work book with week 1 - 5  ending inventory worksheets.  I need vba code to update item cost from a word document w/o changing the previous wks item cost.

    J1549120 pointsBadges:
  • VBA Excel – paste not working

    I have the following piece of code attached to my Excel worksheet:         ActiveSheet.Shapes("Object 407").Select         Selection.Copy         Range("BP106").Select         ActiveSheet.Paste The code is activated by making a choice in a drop down in the worksheet. ...

    Paustin5 pointsBadges:
  • Conditional Hiding of Rows in Excel

    Hi, I work on some projects and I maintain status of those in an excel file in column L. The status of the projects varies as I wrok (Stages). The final status of the project is named as "Completed". Now I want the whole row to get hide when I select the status "Completed" from the list. Eg. If I...

    Khz4315 pointsBadges:
  • format cell based on contents using VB

    i need to change the color of a cell in a specified column based on the value e,g if A1 value is between 1 and 10 then the colo will be red, if the value is between 11-20 then the color will be green etc. i used conditional formats but they only allow for 3 variables i need a script or other that...

    Voicetec15 pointsBadges:
  • Can any one correct this Microsoft Excel VBA code?

    ANY ONE CORRECT THIS Sub fill_series() Dim myrange As Range Set myrange = ActiveCell.Offset(0, 5) Range("N9").FormulaR1C1 = "Apr-2008" Range("N9").Select Selection.AutoFill Destination:=myrange, Type:=xlFillDefault End Sub

    Sa2915340 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following