# Search:

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

Page 1 of 20 1

## Search: Search took 0.09 seconds.

by rory
Replies
8
Views
576

### It's a bitwise OR, so write the two numbers down...

It's a bitwise OR, so write the two numbers down in binary and where either (or both) of the digits is 1, the result is 1, otherwise 0. So:
01000000 = 64
10000000 = 128
----------
11000000 = 192
2. ## Thread: [Excel] Look up target values in a table > Allow editing > Generate a target string

by rory
Replies
1
Views
74

### I'd use a listbox for your UI. It's easy to work...

I'd use a listbox for your UI. It's easy to work with, and is a control that everyone will have, unlike a listview.
3. ## Thread: Data Validation - List change

by rory
Replies
22
Views
560

### It shouldn't be that hard to write. Is that...

It shouldn't be that hard to write. Is that formula entered literally into the DV source, or do you use a named range?
4. ## Thread: Data Validation - List change

by rory
Replies
22
Views
560

### It could be done with code. You'd have to loop...

It could be done with code. You'd have to loop through all validated cells, check if the cell value is the old value, and the validation formula is the one you're looking for, and then update...

by rory
Replies
8
Views
576

### No. A bitwise OR of 0 and any other number just...

No. A bitwise OR of 0 and any other number just returns that other number. There is no point to it.

by rory
Replies
8
Views
576

### The two strings would be converted to numbers,...

The two strings would be converted to numbers, then a bitwise OR is performed. Not a lot of point if one of them is 0 though...

by rory
Replies
9
Views
573

### Yes - a userform can be loaded by any routine.

Yes - a userform can be loaded by any routine.

by rory
Replies
9
Views
573

### Yes - you can use the List property to assign a...

Yes - you can use the List property to assign a whole range at once, which is much faster and better than using AddItem:

DinnerComboBox.List = Sheets("Some sheet").Range("A1:A100").Value

for...

by rory
Replies
9
Views
573

### You'll need a userform. Then you can either use...

You'll need a userform. Then you can either use option buttons or use a combo or listbox.
10. ## Thread: Excel VBA exits on function call

by rory
Replies
5
Views
350

### Since Split returns a String array, I'd use: ...

Since Split returns a String array, I'd use:

Dim s() As String

Yes, if you have no error handler, a function called from a cell will simply terminate.
11. ## Thread: Excel VBA exits on function call

by rory
Replies
5
Views
350

### It's not working because you're trying to use the...

It's not working because you're trying to use the .Value property of a simple data value, and values don't have properties. Also you haven't declared your variables, which is why you get a ByRef...

by rory
Replies
2
Views
110

13. ## Thread: A simpl(ish) way of getting the nth word

by rory
Replies
5
Views
447

### [SOLVED] Perhaps it was one of those air-kiss noises?

Perhaps it was one of those air-kiss noises?
14. ## Thread: Interior color change event

by rory
Replies
4
Views
253

### My point was that I do not think this is an error...

My point was that I do not think this is an error on Microsoft's part. I don't think they should waste time on encouraging bad practices when they have so many other things to concentrate their...
15. ## Thread: Interior color change event

by rory
Replies
4
Views
253

### I feel compelled to reply as this is one of my...

I feel compelled to reply as this is one of my pet peeves. I have to respectfully but completely disagree. This is not MS dropping the ball (Lord knows they have in plenty of areas, and even deflated...
16. ## Thread: Transposing data from a horizontal schedule to a vertical schedule using formulas

by rory
Replies
8
Views
310

### I'd use: C5: =INDEX('RAW...

I'd use:
C5: =INDEX('RAW DATA'!\$C\$6:\$P\$7,MATCH(C\$3,'RAW DATA'!\$A\$6:\$A\$7,0),MATCH(\$A5,'RAW DATA'!\$C\$2:\$P\$2,0))
D5: =INDEX('RAW DATA'!\$C\$6:\$P\$7,MATCH(C\$3,'RAW DATA'!\$A\$6:\$A\$7,0),MATCH(\$A5,'RAW...
17. ## Thread: Excel 2010 The clipboard cannot be emptied. Another program might be using the clipboard.

by rory
Replies
6
Views
222

### Did you install anything between the time it...

Did you install anything between the time it worked and when it stopped?
18. ## Thread: Need formula to eliminate values

by rory
Replies
5
Views
349

### Perhaps: ...

Perhaps:

=IF(LEFT(RIGHT(A1,2),1)="-",LEFT(A1,LEN(A1)-2),A1)
19. ## Thread: Macro to copy values from a closed workbook to the current workbook

by rory
Replies
26
Views
957

### Paul, You can't Dim using a variable - only a...

Paul,
You can't Dim using a variable - only a constant. You have to use Redim if you want to use a variable.
20. ## Thread: Excel 2010: Cannot update. Database or object is read-only

by rory
Replies
7
Views
593

### A couple of observations: 1. ThisWorkbook is...

A couple of observations:

1. ThisWorkbook is not a good variable name - it's an intrinsic Excel object.
2. If you're using 2010, you should be using Microsoft.ACE.OLEDB.12.0 as the Provider, not...
21. ## Thread: Excel 2010 File Sharing Violation - or file corruption ?

by rory
Replies
8
Views
624

### Nope. That's very small compared to most of the...

Nope. That's very small compared to most of the workbooks I deal with at work and even on my work laptop, Excel 2010 has coped with every one of them - apart from one which was 350MB. (Even then...
22. ## Thread: Custom Date Format

by rory
Replies
14
Views
646

### That's true, but then it still requires a lot...

That's true, but then it still requires a lot more effort than simply accepting a normal three letter day abbreviation. I know which option I'd go for. ;)
23. ## Thread: Custom Date Format

by rory
Replies
14
Views
646

### FWIW, you can simplify RG's UDF a little: ...

FWIW, you can simplify RG's UDF a little:

Public Function zMyDteFmt(Target As Range) As String

zMyDteFmt = Left\$(Format\$(Target.Value, "ddd"), 2) & Format(Target, " mmm dd, yy")
...
24. ## Thread: Summarizing the totals of a subtotal worksheet

by rory
Replies
4
Views
279

### Collapse the data so that only the subtotals you...

Collapse the data so that only the subtotals you want are visible. Select those cells, then press Alt+; to select the visible cells only. Now copy and then Paste Special - Values.
25. ## Thread: Formula with 2 IF's and 3rd statement instead of 0 ending

by rory
Replies
1
Views
118

### [SOLVED] Your closing parenthesis is in the wrong place:...

Your closing parenthesis is in the wrong place:
=IF(G3="0","On", IF(G3="1","Off", "please enter 1 or 0 in Cell G3"))
though if the cell should contain a numeric 1/0 rather than "1"/"0", you should...
Results 1 to 25 of 500
Page 1 of 20 1