# Search:

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

Page 1 of 6 1

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

by Domenic
Replies
10
Views
132

### 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. ## Thread: Why is LOOKUP result changing - sometimes to wrong answer

by Domenic
Replies
20
Views
304

### 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. ## Thread: Why is LOOKUP result changing - sometimes to wrong answer

by Domenic
Replies
20
Views
304

### 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. ## Thread: How to copy a picture from one shape to another

by Domenic
Replies
10
Views
132

### 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. ## Thread: How to copy a picture from one shape to another

by Domenic
Replies
10
Views
132

### 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. ## Thread: Why is LOOKUP result changing - sometimes to wrong answer

by Domenic
Replies
20
Views
304

### 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. ## Thread: Why is LOOKUP result changing - sometimes to wrong answer

by Domenic
Replies
20
Views
304

### 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. ## Thread: Why is LOOKUP result changing - sometimes to wrong answer

by Domenic
Replies
20
Views
304

### 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. ## Thread: Why is LOOKUP result changing - sometimes to wrong answer

by Domenic
Replies
20
Views
304

### 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. ## Thread: Dynamic Named Range exclude last row

by Domenic
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. ## Thread: Why is LOOKUP result changing - sometimes to wrong answer

by Domenic
Replies
20
Views
304

### 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. ## Thread: Why is LOOKUP result changing - sometimes to wrong answer

by Domenic
Replies
20
Views
304

### 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. ## Thread: Why is LOOKUP result changing - sometimes to wrong answer

by Domenic
Replies
20
Views
304

### 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. ## Thread: Converting single row in excel to XML document using VBA

by Domenic
Replies
3
Views
73

### 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. ## Thread: Converting single row in excel to XML document using VBA

by Domenic
Replies
3
Views
73

### 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. ## Thread: Use VBA to install Excel Microsoft Scripting Runtime Reference

by Domenic
Replies
12
Views
134

### 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. ## Thread: Use VBA to install Excel Microsoft Scripting Runtime Reference

by Domenic
Replies
12
Views
134

### 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. ## Thread: Use VBA to install Excel Microsoft Scripting Runtime Reference

by Domenic
Replies
12
Views
134

### Re: Use VBA to install Excel Microsoft Scripting Runtime Reference

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

by Domenic
Replies
12
Views
134

### Re: Use VBA to install Excel Microsoft Scripting Runtime Reference

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

20. ## Thread: VBA created Image displays as blank after execution

by Domenic
Replies
1
Views
66

### 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...

by Domenic
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))

by Domenic
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. ## Thread: How do i identify an open powerpoint presentation in excel?

by Domenic
Replies
1
Views
49

### 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."

by Domenic
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. ## Thread: Populating Word 2013 drop down with Excel list

by Domenic
Replies
7
Views
327

### 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