Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.11 seconds.

  1. Replies
    46
    Views
    1,036

    Re: Indirect alternative for external workbook

    May be before going to 2'000, you should restrict your initial test to 20 ...



    Sub LoopGetValues()
    Application.ScreenUpdating = False
    Application.Calculation = xlCalculationManual
    Dim i As...
  2. Replies
    46
    Views
    1,036

    Re: Indirect alternative for external workbook

    My understanding is that your current macro



    Sub Workbook_Open()
    Range("e1") = GetValue([a1], [b1], [c1], [d1])
    Range("e2") = GetValue([a2], [b2], [c2], [d2])
    Range("e3") =...
  3. Replies
    46
    Views
    1,036

    Re: Indirect alternative for external workbook

    First, let me tell you I do appreciate your Thanks ...

    Second ... the question you are now confronted with ... is a totally separate issue ... it only requires a simple loop ....
  4. Replies
    46
    Views
    1,036

    Re: Indirect alternative for external workbook

    Glad to hear it is working fine ...

    You are welcome
  5. Replies
    46
    Views
    1,036

    Re: Indirect alternative for external workbook

    Do you mean you have tested the GetVal() macro ???
  6. Replies
    46
    Views
    1,036

    Re: Indirect alternative for external workbook

    Sub GetVal()
    Dim path As String, file As String, sheet As String, ref As String
    path = [A1]
    file = [B1]
    sheet = [C1]
    ref = [D1]
    [E1] = getvalue(path, file, sheet, ref)
    End Sub
  7. Re: Struggling to produce report based on horizontal table.

    Hello,

    Glad to hear formulas do produce your expected results ...

    In order to adapt them to your real-life workbook, could you clarify

    Everything is located in Sheet1 ...

    1. what is the...
  8. Re: Send different emails to different email ID"s from Excel

    You are welcome
  9. Re: Automatically update cell.value as long as a ActiveX checkbox is checked - excel 365 on WINDOWS

    You are welcome
  10. Re: Automatically update cell.value as long as a ActiveX checkbox is checked - excel 365 on WINDOWS

    Do not feel offended at all ...

    Everybody is on a continuous learning path ..!!! :smile:

    see the Properties 16th item ...
    ...
  11. Replies
    10
    Views
    262

    Re: Showing cell text length while typing

    @ Jaafar ...

    Was hoping you would come up with one of your ' miracle hacks ' ... :smile:
  12. Re: Automatically update cell.value as long as a ActiveX checkbox is checked - excel 365 on WINDOWS

    Say you have selected cell A1 as your LinkedCell for your ActiveX checkBox ...

    In cell O17, you could have following formula:

    =IF(A1,C2,"")

    Hope this will help
  13. Re: Automatically update cell.value as long as a ActiveX checkbox is checked - excel 365 on WINDOWS

    Hello,

    Have you set a cell link for your ActiveX checkbox ... ?
  14. Re: Struggling to produce report based on horizontal table.

    Hello,

    With your table located in Sheet1 in range A1:O6

    and in Sheet2 ...the name Fred in cell B1 ...

    Two array formulas for cell B4 and cell A4:

    cell B4
  15. Replies
    8
    Views
    192

    Re: Number changing to date

    Hello,

    Could you post a couple of examples ... since for 'numbers' to be changed into dates ... is quite a specific issue ... :smile:
  16. Re: Formula equivalent of Goal Seek function. How to manipulate margins based on Pricing requirements?

    Hello,

    In both instances ... goal seek works backwards ... starting from result back to the input ...

    Sadly pictures do not help ...

    Could you explain one single example ... with figures...
  17. Re: VBA Question - I need a macro to move rows of data that meet 1 criteria from one table to another.

    Hello,

    Before getting into moving rows from a table to another one ...

    Have you tried AutoFilter ?
  18. Replies
    10
    Views
    262

    Re: Showing cell text length while typing

    If Jaafar steps in ... be prepared for an extra-ordinary solution ...!!! :smile:

    @ Jaafar ... could you get the keystroke counter to continuously update the cell's comment ... ??? :wink:
  19. Replies
    3
    Views
    86

    Re: dynamic range HORIZTONALLY

    You can test

    =OFFSET(Sheet1!$A$1,0,0,2,COUNTA(Sheet1!$1:$1))

    Hope this will help
  20. Replies
    3
    Views
    86

    Re: dynamic range HORIZTONALLY

    If you know Offset ... you are all set ...

    Offset(ref,0,0, nbRows,nbColumns)
  21. Re: Replicate SUMPRODUCT in VBA to create UDF which is much shorter to simplify appearance of formulae

    Hello,

    You should take a look at Evaluate ... in order to work ou the result of your Sumproduct formula ...

    Hope this will help
  22. Re: Count the # of occurrences in a cell based on a list

    Hello,

    With an Array Formula :

    INDEX($B$1:$B$20,MATCH(TRUE,ISNUMBER(SEARCH($B$1:$B$20, A1)),0))

    Hope this will help
  23. Replies
    6
    Views
    123

    Re: i need some help in userform

    Have you tried :UserForm1.Repaint ...?<code></code>
  24. Replies
    11
    Views
    266

    Re: ActiveX ComboBox Default Value changeable

    Hello,

    First step is to show your UserForm

    Second step is to populate your UserForm with : Private Sub UserForm_Initialize()

    Hope this will help
  25. Replies
    46
    Views
    1,036

    Re: Indirect alternative for external workbook

    TIP from John Walkenbach

    link: http://spreadsheetpage.com/index.php/site/tip/a_vba_function_to_get_a_value_from_a_closed_file/
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4