Search:

Type: Posts; User: erutherford; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    6
    Views
    278

    Re: Conflict with

    forgot the "2"!

    Works perfect.

    I read up on the diff between =index and Iferror

    thanks this was a huge help!
  2. Replies
    6
    Views
    278

    Re: Conflict with

    Can the same be applied to 2nd and third place code?

    <code>
    =IFERROR(INDEX(Entry,MATCH(LARGE(IF(Div=A68,Pts)*(Model=A67),2),Pts,0)),"x")
    </code>

    I modified it, but get a "to few augment...
  3. Replies
    6
    Views
    278

    Re: Conflict with

    Thank you very much! I thought this was going to be difficult to explain and very little response. You nailed it!
  4. Replies
    6
    Views
    278

    Conflict with

    This might be difficult to explain, but I'll give it a shot.

    Basic overview is a table where numerical scores are entered. The scores are ranked 1, 2, and 3 based on the "Div" (Division) and the...
  5. Replies
    6
    Views
    270

    Re: Elseif issue

    yes!
  6. Replies
    6
    Views
    270

    Re: Elseif issue

    If I use this code it functions fine, but I would like to know what rule I broke with the above code.

    <code>
    ThisWorkbook.Sheets("Scores").Activate
    </code>
  7. Replies
    6
    Views
    270

    Re: Elseif issue

    Method "goto of object" application failed
  8. Replies
    6
    Views
    270

    Elseif issue

    Not sure why this gets an error. It seems pretty simple.

    Error occurs at the ElseIf "Application.GoTo ActiveWorkbook.Sheets("Scores").Cells(3, 1)" line

    I replaced it with the App GoTo line...
  9. Replies
    11
    Views
    180

    Re: Option Button/Sorting

    Thanks as always!
  10. Replies
    11
    Views
    180

    Re: Option Button/Sorting

    That did it. Was the duplicate of "This workbook.sheets..." causing the problem?
  11. Replies
    11
    Views
    180

    Re: Option Button/Sorting

    <code>
    <code>ThisWorkbook.Sheets("Entries").Range("A2:J50").Sort Key1:=Range("I2"), Order1:=xlAscending, Header:=xlYes
    </code>
    </code>
  12. Replies
    11
    Views
    180

    Re: Option Button/Sorting

    I hoping you were out there watching! Sorry about the typos, I have played with this section way to many times!

    I still get the error

    <code>
    Private Sub CommandButton8_Click()
    Unload...
  13. Replies
    11
    Views
    180

    Re: Option Button/Sorting

    I think you may be correct on your answer. So in order to troubleshoot this I am using 3 separate command buttons. So now I only have to deal with one issue, I hope.

    A command button opens...
  14. Replies
    11
    Views
    180

    Option Button/Sorting

    The project has grown and has a few pains still and this is one. Sometimes it will work and sometimes it doesn't and not sure why. The objective is to sort on Col "J " within a range. Seems...
  15. Replies
    0
    Views
    71

    Automated emails based on date

    Found tons of info on this, but this config might be out of my league. I was able to send and receive an email through excel with this code. Is it possible to do the following with this code. I am...
  16. Re: Simple question - Simple Solution - Last Row

    Rory,
    You were spot on, ".row" solved the issue. Just took a while to get back to the project. Thanks for sticking with me on this!

    till next time.......
  17. Re: Simple question - Simple Solution - Last Row

    object -defined error still occurs at the first textBox1 value

    <code>
    LastRow = Cells(Rows.Count, 1).End(xlUp).Offset(1)
    Cells(LastRow, 1) = TextBox1.Value 'FN
    Cells(LastRow, 2) =...
  18. Re: Simple question - Simple Solution - Last Row

    Rory & Neil,
    Here is the entire code for the command button. It just a basic contact form.



    Private Sub CommandButton1_Click()

    'FN
    If TextBox1.Value = "" Then
  19. Re: Simple question - Simple Solution - Last Row

    Rory
    I did read where "select" is not the best way to go. But the "cells(LastRow)" creates an error at the first line ('FN)



    MsgBox "Information Complete, Thank You"
    Unload UserForm1...
  20. Re: Simple question - Simple Solution - Last Row

    found this code which seems to have solved the issue

    <code>
    Cells(Rows.Count, "A").End(xlUp).Offset(1, 0).Select
    </code>

    Counting up is a better fit, than counting down.

    Joe4 posted this...
  21. Re: Simple question - Simple Solution - Last Row

    Nope that produces the same error at

    Cells(LastRow, 1) = TextBox1.Value
  22. Simple question - Simple Solution - Last Row

    I have a table with headers (starting in A1), nothing fancy. I have a form that controls the data that is entered, works fine.

    If the table is empty with only the headers there, I get an error...
  23. Replies
    7
    Views
    149

    Re: =sumproduct

    the "why" is almost as important as the results!

    thanks for pursuing!
  24. Replies
    7
    Views
    149

    Re: =sumproduct

    The formula would just display in the cell and not function
  25. Replies
    7
    Views
    149

    Re: =sumproduct

    Ok I just try it on the worksheet where it should be, using another cell and it works

    I just cut it from the test cell and pasted it into the correct cell and its functioning. I did delete a...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4