Search:

Type: Posts; User: Jon von der Heyden; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.36 seconds.

  1. Re: Data Query from WEB ( Unexpected Error)

    Duplicate: https://www.mrexcel.com/forum/power-bi/1085412-unexpected-error-something-went-wrong-when-trying-edit-query-post5320611.html#post5320611

    Per the forum rules please address your...
  2. Re: Using Macros, Hide (with password) and Unhide multiple worksheets

    Cross-posted here: https://www.excelforum.com/excel-programming-vba-macros/1285668-macro-to-make-an-array-of-worksheets-veryhidden.html

    @aduttonusa - Whilst do not forbid cross-posting here at...
  3. Re: Macro to choose file and add name to a cell

    Good job Tony. To get filename only use:


    Dir$(.SelectedItems(1))
  4. Re: Macro to choose file and add name to a cell

    Hi Tony

    I don't know what an AMF file is but I am assuming it has amf extension (see filter in code below). The cod will display selected file name in message box but you can write it to a cell...
  5. Re: Dividing fractions into new cell

    If it's text you could try:

    =LOOKUP(10^9,--LEFT(A1,{1;2;3;4;5;6;7;8;9}))/LOOKUP(10^9,--RIGHT(A1,{1;2;3;4;5;6;7;8;9}))
  6. Re: Vlookup - Look for a value in a filtered list

    Bu cross-posting I mean instances where you are asking the same question across multiple forums. In this instance it appears that you also asked this question on Excel Forum - the requirement is...
  7. Re: Reverse the order of the new worksheet

    To have it as the first sheet, use Before, instead of After, and reference Worksheets(1​)
  8. Re: Vlookup - Look for a value in a filtered list

    Cross-posted here: https://www.excelforum.com/excel-formulas-and-functions/1284190-vlookup-look-for-a-value-in-a-filtered-list.html#post5163442

    Hi Gemini and welcome to the board.

    We do not...
  9. Re: Pass Worksheet_Change Target Value to Userform

    You could also create a userform property to hold the value, or even reference the target range. For example, using a userform called UserForm1:

    Sample code in UserForm1:


    Private m_rngTARGET...
  10. Re: Loop through 2 columns and and return TRUE or FALSE if adjscent cells are matching.

    Try:

    =IFERROR(VLOOKUP(C1,A:B,2,0)=D1,FALSE)
  11. Re: cell set as range not recognized

    You haven't Set the range ;-)

    I.e.


    Set onedeg = ...
    Set onecon = ...
  12. Re: Transpose problem: produces zero results

    For what it's worth.
  13. Re: Limited to the amount of Locked Cells?

    Hi

    I am not aware of any limits. I also didn't see any reference to locked cells here:...
  14. Replies
    1
    Views
    86

    Re: Sumif filtered criteria

    Welcome to the board!

    Example here: http://www.xl-central.com/sum-single-criteria-filter.html

    So in your case:
    ...
  15. Re: Excel spontaneously changes reference to linked workbook

    Cross psoted here: https://www.excelforum.com/excel-formulas-and-functions/1283885-excel-spontaneously-changes-formula-linking-two-workbooks.html

    Per moderator reply at Excel Forum - we too...
  16. Re: Excel Power Query Automate Import of File Navigation

    Duplicate: https://www.mrexcel.com/forum/power-bi/1104789-automatically-import-text-files-via-power-query.html

    Please stick with your original thread, per the forum rules. Post all...
  17. Replies
    3
    Views
    178

    Re: Vlookup from external workbook

    Keep in mind that the workbook will need to be open. INDIRECT will return #REF ! error if the workbook is closed. * Unless it has changed in Excel 2016 (untested).
  18. Re: Find week number based my current financial year start date in VBA/Excel

    Cross-posted here: https://stackoverflow.com/questions/57073772/find-the-week-no-in-a-month-based-on-the-financial-calendar-in-vba

    Whilst we allow cross-posting here (most forums don't) we do...
  19. Replies
    6
    Views
    370

    Re: compare columns

    or:


    Public Sub IloveVBA()
    Dim rng1 As Excel.Range
    Dim rng2 As Excel.Range
    Dim rngCell As Excel.Range
    Dim strJustynasFormula As...
  20. Re: how to change colour of cell if anything is entered in textbox

    Howdy

    Remove the = ""


    If Len(TextBox14.value) = "" Then
  21. Re: how to change colour of cell if anything is entered in textbox

    You could check that the length of the text in the TextBox is not 0:



    If Len(TextBox14.Value) Then
  22. Re: DATEVALUE in Excel, handy tips?

    Hi

    What version of Excel are you using?

    Assuming I understand your question, both WEEKNUM and WEEKDAY functions support unnatural selections, although I cannot recall when this came in to...
  23. Re: Parsing a formula: qualify sheet for all range references

    Wonderful - thank you Pedro! Very cunning workaround and it seems to be working a treat!
  24. Re: Parsing a formula: qualify sheet for all range references

    Hi Marcelo

    Thanks though for having a crack. Still gives food for thought because Worksheet.Evaluate could indeed have offered some for of workaround.
  25. Parsing a formula: qualify sheet for all range references

    Hi All

    I have a very large workbook with a large volume of validation rules across multiple sheets. The validation uses custom hence standard formulas that evaluate to either TRUE/FALSE.

    I...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4