Search:

Type: Posts; User: Merton

Search: Search took 0.02 seconds.

  1. Re: creating invoice & getting employees perfurmance

    This job is would be better handled by a database than a spreadsheet. Consider using Access or another simple database program.
  2. Replies
    9
    Views
    3,512

    Re: Calculate & Store using Excel 2007 vba

    Of course You are right about the actual work being done in this question.
    I (admittedly reading between the lines) took this as coming from someone looking to learn VBA, not really how to perform a...
  3. Replies
    9
    Views
    3,512

    Re: Calculate & Store using Excel 2007 vba

    I assume it's part of a larger program. Or I did his homework for him.
  4. Replies
    9
    Views
    3,512

    Re: Calculate & Store using Excel 2007 vba

    There are many problems with your code.
    Lets go through it line by line.

    Dim r1, r2, r3 As Integer
    Here you are telling Excel that you are going to be using r1, r2, and r3 as Variables which...
  5. Replies
    2
    Views
    423

    MsOf10 Re: Overstepping the Error?

    The problem is that the purpose of
    On Error Resume Next
    is to ignore the error and continue. It does this by setting Err.Number = 0.


    You need to use On Error Goto
    Like this

    Sub MySub
    For...
  6. MsOf03 Re: Could anyone explain why this doesn't work please?

    Looks like you are moving down a row after you check if it is Yesterday.
    Then you are hitting the loop.
    if the new row is Yesterday then the loop ends.

    to fix this, start a row higher and move...
  7. Re: [EXCEL] Inconsistent Comparisons Between Cells?

    The first thing that stands out to me is you are setting myCheck equal to ActiveCell.Value but comparing it to just ActiveCell. depending on how those numbers get to the sheet it could give...
  8. Replies
    1
    Views
    456

    Re: If character [something] of string =

    That is an awfully vague question and it doesn't sound like something you would be doing in VBA, Probably VB6.
    if I understand from you title you want something like this.

    If Left(YourString,3) =...
  9. Replies
    2
    Views
    667

    MsOf07 Re: ActiveCell.Replace difficulty

    try this

    If Right(ActiveCell.Value, 3) = " ST" Then
    ActiveCell.value = ActiveCell.Value & "REET"
    End If
Results 1 to 9 of 9



Click Here to Expand Forum to Full Width