vba problem

  1. 1

    How to use solver for this case?

    The exercise is: There are 5 employees in your small business who can perform any of the 5 different tasks that your company has. The following table shows how many hours of working time are required for each employee to perform each obligation. Your job is to split these responsibilities so...
  2. S

    Please Help me with this VBA

    This VBA code I am using has a problem I hope someone can help me with. The code is posted below. What the code does is concatenate columns A-G into K but what makes it unique is it bolds the first sentence of each cell in the result column K and preserves the way dates are actually appearing...
  3. M

    VBA code exits before completing

    I'm using Excel 2003 and my code is supposed to delete the calculations leaving just the values. Everything seems to be working like it should 'till the code is supposed to delete the original data rows / columns: Rows("1:67").Delete Shift:=xlUp Columns("A:AJ").Delete Shift:=xlToLeft The code...
  4. N

    text box validation

    I'm trying to find some code which when exiting a VBA text box will check its contents are in the right format I.e time or %. What would the code be to throw up a stop message if incorrect?
  5. P

    filesearch excel 2003 to 2007

    Hello This works fine with excel 2003, but now I´m moving to excel 2007 and don´t know how to change "filesearch" code. Can anyone help me?? thanks in advanced _____________________________________ Private Sub Workbook_Open() Application.DisplayAlerts = False On Error Resume Next...
  6. L

    VBA FormulaR1C1 problem

    Hi, I'm trying to input a formula into a cell using the FormulaR1C1 method, but I've hit a small problem. Basically the formula I'm inputing refers to the adjacent cells e.g. Activecell.FormulaR1C1 = "=RC[-1]+RC[-2]..." However what I'm wondering is is it possible to input a formula that...
  7. L

    vba cell resizing problem

    Hi, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I've got a For..Next statement that inputs a piece of text into the activecell, then colours the cell and adds a border. My problem now is that I need it to adjust the column width so I can...
  8. L

    vba Formula Problem

    Hi, I'm wanting to input a formula (and not a value) into the activecell, which adds the first cell to the left and right of the activecell e.g. if my activecell was B1 the formula would be "=A1+C1" What I'm wondering is, is it possible to generalise the above, that is, if my activecell was E1...

Some videos you may like

This Week's Hot Topics