Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.78 seconds.

  1. Re: How to copy a picture from one shape to another

    Sorry, I thought we were dealing with shapes (ie. circle, rectangle, et.). I guess this is not the case, correct?
  2. Re: Why is LOOKUP result changing - sometimes to wrong answer

    Actually, I'm not a member of that forum. Can you just copy/paste the data? Then I'll test your formula.
  3. Re: Why is LOOKUP result changing - sometimes to wrong answer

    By the way, my formula should be amended to use IFERROR instead...


    =IFERROR(INDEX(F$1:F1,MATCH(2,IF(B$1:B1=B2,IF((E$1:E1=TRUE)+(F$1:F1=TRUE)>0,1)),1)),"-")

    I initially used...
  4. Re: How to copy a picture from one shape to another

    Here's another way...


    Dim n As Long
    With Worksheets("Print Label")
    .Shapes("Choice").PickUp
    For n = 1 To 45
    .Shapes("Icon " & n).Apply
    Next n...
  5. Re: How to copy a picture from one shape to another

    Hi lrobbo314,

    Just wanted to point out that you forgot to qualify your reference...


    With ws.Pictures.Insert(PicPath)

    Cheers!
  6. Re: Why is LOOKUP result changing - sometimes to wrong answer

    Your formula looks fine. I have tested your formula, and it seems to return consistent results. Can you provide the sample data where the formula does not return the desired result?
  7. Re: Why is LOOKUP result changing - sometimes to wrong answer

    Unless I missed it, I don't think you posted the actual formula you were using. What was your formula?
  8. Re: Why is LOOKUP result changing - sometimes to wrong answer

    In that case, try the following instead...

    H2, confirmed with CONTROL+SHIFT+ENTER, and copied down:

    ...
  9. Re: Why is LOOKUP result changing - sometimes to wrong answer

    Sorry, I'm still unclear. Can you please clarify? It would help if you could run through a few examples that cover all scenarios.
  10. Replies
    1
    Views
    45

    Re: Dynamic Named Range exclude last row

    If Column A contains text values, try...


    =Data!$A$2:INDEX(Data!$A:$U,MATCH(REPT("z",255),Data!$A:$A,1)-1,COLUMNS(Data!$A:$U))

    or

    ...
  11. Re: Why is LOOKUP result changing - sometimes to wrong answer

    It looks like a more accurate description of the desired result is that you want to check whether a team received a red card in any of their previous games, not just the last game. If this is...
  12. Re: Why is LOOKUP result changing - sometimes to wrong answer

    You can simply add borders around your cells, and then copy and paste the data into your post...
  13. Re: Why is LOOKUP result changing - sometimes to wrong answer

    The lookup vector/range must be sorted in ascending order, as per Excel's help file...



    If you need further help, try posting a small sample of the data, along with the expected results.
  14. Re: Converting single row in excel to XML document using VBA

    Just a slight amendment to the code so that you won't have to worry about removing spaces from your column headers. The following changes in red will replace any spaces with an underscore (_).


    ...
  15. Re: Converting single row in excel to XML document using VBA

    The reason why you're getting a blank file is that you're actually getting an error when you try to load your XML data. That's because you need at least one root or top element in an XML file. You...
  16. Re: Use VBA to install Excel Microsoft Scripting Runtime Reference

    You didn't say which line is causing the error, but since you're using late binding you'll need to replace the constant ForWriting with the actual value, which is 2...


    Set stream =...
  17. Re: Use VBA to install Excel Microsoft Scripting Runtime Reference

    Hi Sebastian, I just thought I would point out that you forgot to declare stream as Object...


    Dim stream As Object

    Cheers!
  18. Re: Use VBA to install Excel Microsoft Scripting Runtime Reference

    You'll need to allow access to the VBA project object model...


    File >> Options >> Trust Center >> Trust Center Settings >> Macro Settings >> Developer Macro Settings >> select/check 'Trust...
  19. Re: Use VBA to install Excel Microsoft Scripting Runtime Reference

    It looks like you have a typo. The last backslash (\) should be a dot (.)...


    Application.VBE.ActiveVBProject.References.AddFromFile "C:\Windows\SysWOW64\scrrun.dll"
  20. Re: VBA created Image displays as blank after execution

    First, I'm assuming that you want the width and height of your image the same size as your selected range of cells. Secondly, it looks like you're missing a backslash (\) from your destination path...
  21. Replies
    3
    Views
    84

    Re: Object Qualifies

    I just meant that you need to add a reference to the sheet containing the textbox, as I've shown in my example, like this...


    Worksheets("Sheet1").TextBox1.BackColor = RGB(255,0,0))
  22. Replies
    3
    Views
    84

    Re: Object Qualifies

    It looks like you have an ActiveX control that's located on a worksheet. If this is correct, you'll need to qualify your sheet reference. Also, you'll need to use the BackColor property of the...
  23. Re: How do i identify an open powerpoint presentation in excel?

    Try the following macro...


    Option Explicit

    Sub ChartX2P()


    If ActiveChart Is Nothing Then
    MsgBox "Hey, please select a chart first."
  24. Replies
    2
    Views
    49

    Re: VBA add new sheet to End of Workbook

    Your code actually contains instructions to create two sheets. The first line creates a sheet, adds it to the end of the workbook, and gives it a default name. The second line creates another...
  25. Re: Populating Word 2013 drop down with Excel list

    When you say that you are unable to get it to work, what do you mean exactly. Do you get an error? If so, which one and on which line? Also, did you make the necessary changes, where indicated in...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4