Recent content by JoeHart

  1. J

    Solved: Excel 2003 + ambiguous name detected

    That worked great. I had to change the line "If Len(Target) > 7 Then" to "If Len(Target) >= 7 Then" Same thing for the "If Len(Target) >= 3 Then" It would not write the values if I had all the boxes full. I would have never thought to break up the Target using "ElseIf Mid(Target.Address, 2...
  2. J

    Solved: Excel 2003 + ambiguous name detected

    Forget about my last commit. I made it stop adjusting the column width, by changing the cell format to text.
  3. J

    Solved: Excel 2003 + ambiguous name detected

    I did not see that you had already solved it before me. Anyway I noticed one more thing. When I type more than one digit into the cell, it trys to adjust the width of the colum to accomidate all the numbers before it move them to the other columns. I would like it to leave the column width...
  4. J

    Solved: Excel 2003 + ambiguous name detected

    I think I got it but would like two thing fixed. Below is the code I used (just a modification of your code). If I don't use 3 digits in the first section or 7 in the second section, I would like the remaining spaces to be overwritten with a " "(blank space) so that if something is already in...
  5. J

    Solved: Excel 2003 + ambiguous name detected

    Sorry I think I wrote the code wrong when I moved it to the sheet. I would like to combine the first set of codes with the three cases that monitors cells ("P8:P18,P23:P30") and the second Code with three cases that monitors ("T8:T18,T23:T30") like below (if I don't mess it up again). The...
  6. J

    Solved: Excel 2003 + ambiguous name detected

    Hi, How do I combine two different macros so that I don't get the error ambiguous name detected? Private Sub Worksheet_Change(ByVal Target As Range) Dim Rng As Range On Error GoTo ErrHandler If Target.Cells.Count > 1 Then Exit Sub Set Rng = Range("T8:T18,T23:P30") If...
  7. J

    Solved: Macro causing more problems

    I made a minor change just in case there were two digits, but it worked great. This way seems much easier to understand too. Thanks, Joe Private Sub Worksheet_Change(ByVal Target As Range) Dim Rng As Range On Error GoTo ErrHandler If Target.Cells.Count > 1 Then Exit Sub...
  8. J

    Solved: Macro causing more problems

    I know I should be able to and that is why it is bothering me. Here is my attempt. I tried to use Range(ActiveCell.Offset(1, 0), Cells(cRow, cCol)).Select from inside the funciton, but once it finished with the function I think it went back to the original cell. I think the target offset is...
  9. J

    Solved: Macro causing more problems

    Hi, In the attached timesheet, in cell P8, if I enter 1 digit and press enter or tab I would like it to go to the next cell Q8. If I enter 3 numbers and press enter I would like it to go down 1 cell to P9. If I Press tab it should always go to the right 1 place. The problem is I have a macro...
  10. J

    Solved: Next Cell Macro

    Hi Hans, I figured it out, with your help of course. Sorry this missed you before your trip, I coached little leage baseball all weekend. Below is the code with the changes I made. I hope it makes sense, and I surrounded the code correctly to make it easy to read. Basically this code will...
  11. J

    Solved: Next Cell Macro

    It works perfect for 3 digits but if I only enter one digit than that digit should stay in that cell and not enter 00# across the three cells. In other words the macro should not do anything. I am going to try it see if I can fix it, but like I said I am just a beginner.
  12. J

    Solved: Next Cell Macro

    Your too fast. I have not got a chance to try either macro but I will in a few minutes. As far as your question if they only enter a digit 1-9 in the first cell than it will stay in that cell. If there is something already in one of the other cells and they type 123 in the first cell it...
  13. J

    Solved: Next Cell Macro

    Hi Wendy, I am not sure if it is possible either, but I don't see why it would not be. I know how to use left(O8,1) mid(O8,2,1) and right(O8,1), but my company is not very flexible. They don't accept change very easy so I need to make it as close to what they are used to as possible...
  14. J

    Solved: Next Cell Macro

    I have searched the net and what I am asking does not seem possible, but is there a way that if someone enters "123" into cell O8 and presses enter that a Macro takes that number and puts the 1 in O8 the 2 in P8 and the 3 in Q8.
  15. J

    Solved: Next Cell Macro

    Hi I am creating a company wide timesheet. I have a a group of cells O8, P8, and Q8 that I enter a single digit 1-9 that I would like it to advance to the next cell. This would need to be done for O8 - O34, same with P and Q. So if I enter 0 in O8 it should automatically go to the next cell...
Top