Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 1.11 seconds.

  1. Re: Delete row if specific cell value matches value found in another worksheet

    Hi

    You have posted to an old thread. Many members including me are now "retired" from the board. Please start your own, new, thread. :biggrin:
  2. Replies
    2
    Views
    266

    Re: Value of last cell in range

    Duplicate http://www.mrexcel.com/forum/excel-questions/847064-value-last-cell-range.html
  3. Re: Putting userform Data into a different worksheet

    You shouldn't need to select the sheet/range to work with it but try



    Sheets("ADMIN_UserFormEntry").Select
    Range("A2").Select
  4. Thread: Trigonometry

    by VoG
    Replies
    1
    Views
    168

    Re: Trigonometry

    Just a few :)

    https://support.office.com/en-sg/article/Math-and-trigonometry-functions-reference-6f9459d3-0c22-42fa-9e84-218c11325ecd
  5. Replies
    6
    Views
    868

    Re: dynamic values in a chart

    This may help you Dynamic and Interactive Charts
  6. Replies
    4
    Views
    256

    Re: VBA for deleting 0 value only

    Perhaps



    Set c = SrchRng.Find("0", LookIn:=xlValues, lookat:=xlWhole)
  7. Replies
    2
    Views
    343

    Re: Drop down list font size

    One way http://www.contextures.com/xlDataVal10.html
  8. Thread: Delete Column

    by VoG
    Replies
    3
    Views
    241

    Re: Delete Column

    Try working backwards



    Sub delete_Column()
    If Range("D1").Value = "" Then Columns("D").Delete
    If Range("C1").Value = "" Then Columns("C").Delete
    End Sub
  9. Thread: Delete Column

    by VoG
    Replies
    3
    Views
    241

    Re: Delete Column

    Try



    Sub test()
    If Range("C1").Value = "" Then Columns("C").Delete
    End Sub
  10. Replies
    4
    Views
    241

    Re: search all in excel

    Some code that I wrote a long, long time ago



    Sub FindHighlight()
    Dim tempcell As Range, Found As Range, sTxt, FoundRange As Range, Response As Integer
    Set Found = Range("A1")
    sTxt =...
  11. Thread: "IF" formula help

    by VoG
    Replies
    17
    Views
    502

    Re: "IF" formula help

    Maybe like this

    =IF(OR(A1=200,A1=300),A1,"")
  12. Replies
    2
    Views
    181

    Re: Open another file with cod

    Like this?



    Workbooks.Open Filename:="C:\TEST.XLSX", Password:="123"
  13. Replies
    6
    Views
    749

    Re: Posting files for review

    Personally I like Excel Jeanie Excel Jeanie Html
  14. Replies
    1
    Views
    165

    Re: Help regarding Product & If function

    Try in H12

    =IF(F48>0,H10*H13,"Clear")
  15. Thread: Self teacher

    by VoG
    Replies
    4
    Views
    212

    Re: Self teacher

    Hello. You could create a table of your drivers and their attributes then use VLOOKUP to return the information from that table.

    Here's a (randomly selected) tutorial Excel Lookup & Reference...
  16. Re: Run time error 13 mistype. how do i stop this? please

    Perhaps



    If Target.Address(False, False) = "D3" Then
  17. Replies
    6
    Views
    412

    Re: One specific file gives errors

    Then maybe try http://www.mrexcel.com/forum/excel-questions/223851-rebuild-your-workbook.html
  18. Replies
    6
    Views
    412

    Re: One specific file gives errors

    This may help you...
  19. Replies
    1
    Views
    600

    Re: Excel VBA find empty row script error

    That shouldbe



    eRow = Invoice.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row



    l not 1
  20. Re: Vba open workbbok and paste from another workbook

    Cross posted Vba open workbook and paste from another workbook
  21. Replies
    3
    Views
    533

    Re: Happy Birthday Bill Jelen (aka Mr Excel)!

    Many happy returns, Bill :beerchug:
  22. Replies
    4
    Views
    218

    Re: Using Cell Address in a Formula

    Try

    =OFFSET(INDIRECT(A1),2,0)
  23. Replies
    4
    Views
    218

    Re: Using Cell Address in a Formula

    Try


    =INDIRECT(A1)
  24. Replies
    1
    Views
    299

    Re: value of the day in the year

    This may help Day of the Year in Excel - Easy Excel Tutorial
  25. Re: Converting Conditional Formating into VBA Code

    This may help you Conditional Formatting Colors
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4