# Search:

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

Page 1 of 6 1

1. ## Thread: SUMIF Formula where Excel is treating the Date criteria as Text

by RoryA
Replies
5
Views
49

### Re: SUMIF Formula where Excel is treating the Date criteria as Text

That does tend to confirm that the numbers in H are not numbers. What does:

=SUM(H:H)

return? 0?
2. ## Thread: General knowledge on datepicker - 32 bits vs 64 bits compatibility

by RoryA
Replies
4
Views
11

### Re: General knowledge on datepicker - 32 bits vs 64 bits compatibility

I mean that you either add the control to your userform when it loads, rather than having it already present (will require more coding), or use a totally different approach, such as a separate...
3. ## Thread: How to create arrow that grows with size of value

by RoryA
Replies
2
Views
106

### Re: How to create arrow that grows with size of value

It could have been made with something like Tableau, but you can create a bar chart in Excel and then just copy and paste an arrow shape onto the chart series to achieve something similar.
4. ## Thread: SUMIF Formula where Excel is treating the Date criteria as Text

by RoryA
Replies
5
Views
49

### Re: SUMIF Formula where Excel is treating the Date criteria as Text

That would make me think that my first suggestion is the problem. What does:

=countif(L:L,O6)

return?
5. ## Thread: General knowledge on datepicker - 32 bits vs 64 bits compatibility

by RoryA
Replies
4
Views
11

### Re: General knowledge on datepicker - 32 bits vs 64 bits compatibility

If you didn't save the file, it would still work on 32 bits. You cannot code round this problem if the control is present when the workbook opens, so if you need to support 64bit versions, either...
6. ## Thread: Ampersands Appearing in Formulas

by RoryA
Replies
2
Views
53

### Re: Ampersands Appearing in Formulas

When the @ symbol appears before a function, it's because the function uses implicit intersection, and this doesn't fit with the new dynamic array formulas (@ is actually a replacement for the...
7. ## Thread: In user subscribed threads there is no display of no(s) of views and replies

by RoryA
Replies
1
Views
31

### Re: In user subscribed threads there is no display of no(s) of views and replies

You can't as far as I know. Why is it important?
8. ## Thread: SUMIF Formula where Excel is treating the Date criteria as Text

by RoryA
Replies
5
Views
49

### Re: SUMIF Formula where Excel is treating the Date criteria as Text

I'd say the more likely cause is that either the numbers in column H are actually text, or the dates really don't match (eg if there's a time portion in one or other).
9. ## Thread: Worksheet Display Not Updating Through Loop Process

by RoryA
Replies
3
Views
74

### Re: Worksheet Display Not Updating Through Loop Process

Probably because the Import procedure turns screenupdating off and doesn't turn it back on, so you'll only get an update when all the code has finished.
10. ## Thread: Argument not optional problem If Not Intersect Private Sub Worksheet Change

by RoryA
Replies
2
Views
56

### Re: Argument not optional problem If Not Intersect Private Sub Worksheet Change

There should be a comma there, not a full stop:

If Not Intersect(Target, Range("I8:I32")) Is Nothing Then

by RoryA
Replies
4
Views
44

### Re: Load Exported.UI file on Work book start up

Believe me, that way is considerably easier than what you are attempting as an alternative. :)

by RoryA
Replies
4
Views
44

### Re: Load Exported.UI file on Work book start up

You're going about it the wrong way. You should read this: http://www.rondebruin.nl/win/s2/win001.htm
13. ## Thread: VBA for Sumifs not working

by RoryA
Replies
2
Views
25

### Re: VBA for Sumifs not working

The last part should be:

ThisWorkbook.Sheets("First line manager").Cells(z, 1)

and not:

ThisWorkbook.Sheets("First line manager"), Cells(z, 1)
14. ## Thread: What is early binding and late binding

by RoryA
Replies
12
Views
838

### Re: What is early binding and late binding

The late binding is correct but you would of course need to remove the early bound Public variables.
15. ## Thread: What is early binding and late binding

by RoryA
Replies
12
Views
838

### Re: What is early binding and late binding

Yes it is, though there is no point for native Access objects like QueryDef.
16. ## Thread: What is early binding and late binding

by RoryA
Replies
12
Views
838

### Re: What is early binding and late binding

The first two pairs are early binding, the last is late binding (declared as Object).
17. ## Thread: Microsoft Access 14.0 Object Library

by RoryA
Replies
6
Views
574

### Re: Microsoft Access 14.0 Object Library

To be honest, if you can't tell by reading the code, you probably shouldn't be editing it. At any rate, you cannot remove a reference to the host application.
18. ## Thread: Microsoft Access 14.0 Object Library

by RoryA
Replies
6
Views
574

### Re: Microsoft Access 14.0 Object Library

Why would you attempt to uncheck an Access reference when you are working in Access?
19. ## Thread: Extracting text from a cell when the location is different each time.

by RoryA
Replies
4
Views
127

### Re: Extracting text from a cell when the location is different each time.

Welcome to the forum.

Assuming you don't have anyone using 100GB or more, something like this should work:

=TRIM(MID(" "&E7,SEARCH("GB"," "&E7)-2,4))
20. ## Thread: object required error 424

by RoryA
Replies
2
Views
110

### Re: object required error 424

It seems you have subsequently asked this same question elsewhere, so I'll close this to avoid anyone else wasting their time.
21. ## Thread: Macro not compatablie with Macs

by RoryA
Replies
4
Views
202

### Re: Macro not compatablie with Macs

It's easier to use conditional compilation, in my opinion:

#If Mac then
' do Mac things
#Else
' do Windows things
#End If
22. ## Thread: What is early binding and late binding

by RoryA
Replies
12
Views
838

### Re: What is early binding and late binding

Simply put:
Late binding = declaring obejct variables as Object.
Early Binding = declaring object variables as a specific type.
23. ## Thread: object required error 424

by RoryA
Replies
2
Views
110

### Re: object required error 424

Remove the .Activate part.
24. ## Thread: PutInClipboard Office 365

by RoryA
Replies
5
Views
67

### Re: PutInClipboard Office 365

It's actually nothing to do with Office. There's a bug in Windows 8 and later that causes this to happen if you have File Explorer windows open. You should use Windows API calls to put text in the...
25. ## Thread: Runtime Error 13: Type-Mismatch

by RoryA
Replies
2
Views
52

### Re: Runtime Error 13: Type-Mismatch

You've declared fDelimiters as an array, but in examples 1 and 2, Delimiters(0) is not an array, it's a string, so this will fail with a type mismatch:

fDelimiters = Delimiters(0)
Results 1 to 25 of 150
Page 1 of 6 1