# Search:

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

Page 1 of 6 1

## Search: Search took 0.04 seconds.

by WillR
Replies
5
Views
307

Well, there's a saying here that asking someone to recommend a course of action likely to be non beneficial to themselves would be like expecting Turkeys to vote for Christmas (when turkey is the...

by WillR
Replies
5
Views
307

If he's serious, he should get a consultant to do it...

But Turkeys & Christmas springs to mind :laugh:
3. ## Thread: Tricky VLOOKUP Question?

by WillR
Replies
19
Views
799

### Re: Tricky VLOOKUP Question?

Or

=DSUM(A1:B13,"Value",E1:E2)

Where A1:B13 is your data table

E1 contains the value "Product" (without quotes)
E2 contains the value "A" (without quotes)
4. ## Thread: Why MrExcel is like Hitch Hiking

by WillR
Replies
50
Views
3,257

### Re: Why MrExcel is like Hitch Hiking

Because i'm stoooopid

Started telling the story of the two Birminghams and then realised it had been linkedto already earlier in the post :)

by WillR
Replies
50
Views
3,257

oops
6. ## Thread: Clearcontents in a cell with a commandbutton

by WillR
Replies
2
Views
342

### Re: Clearcontents in a cell with a commandbutton

Try this

For x = 0 To ListBox1.ListCount - 1
If ListBox1.Selected(x) = True Then
With Worksheets("XWorksheet").Range("A2:A30")
.Cells(x + 1).ClearContents
End With

End If
7. ## Thread: When is MREXCEL coming to England?

by WillR
Replies
118
Views
13,806

### Bill, Try the Universities - they are usually...

Bill,

Try the Universities - they are usually more reasonable - there are 2 in Birmingham, of which Aston is probably better located being nearer the city centre...

...
8. ## Thread: Change worksheet's name in an unsaved workbook

by WillR
Replies
1
Views
533

### Try this Sub addnewbook() Dim NewBook As...

Try this

Dim NewBook As Workbook

With NewBook
.Worksheets("Sheet1").Name = "Something Else"
9. ## Thread: When is MREXCEL coming to England?

by WillR
Replies
118
Views
13,806

### Birmingham

Yep,

Whether I come to the seminar or not, I'll certainly be around for a "night before" few beers. Richie Sills is still around in Birmingham too (Richie(UK)) - we can rustle a few people up for...

by WillR
Replies
1
Views
416

### Well, I would do this by passing a SQL Query to...

Well, I would do this by passing a SQL Query to your MySQL Database.

You will need to connect using a connection string such as

Driver={MySQL ODBC 3.51...
11. ## Thread: Excel Guru / VBA Experts.

by WillR
Replies
2
Views
967

### Some XL/VBA "Gurus" gain work almost exclusively...

Some XL/VBA "Gurus" gain work almost exclusively in a consultancy role (though there are only a few who can make a living from XL/VBA consulting alone). Therefore many have other programming...
12. ## Thread: big fuss - excel 2007

by WillR
Replies
9
Views
1,023

### Poll: LOL Kristy :lol: :-D :outtahere:

LOL Kristy :lol: :-D :outtahere:

by WillR
Replies
16
Views
1,643

### Poll: Hiya Greg The emoticons I would suggest are ...

Hiya Greg

The emoticons I would suggest are

:lol: :x :o :-D :huh: :!:

Office 12 evokes all of the above emotions... but the more I use it the more I like it... in fact for the first...

by WillR
Replies
37
Views
7,566

### Yes, i guess on balance it has. But actually...

Yes, i guess on balance it has.

But actually it was probably discovering the incredible learning resources available on the .net that has helped me to advance my career, not just specifically...

by WillR
Replies
16
Views
1,643

### Poll: There's a 60 day trial version available (at...

There's a 60 day trial version available (at least here in the UK) for just that purpose

http://ukireland.trymicrosoftoffice.com/

by WillR
Replies
16
Views
1,643

### Poll: Yes I already have. I love it. Sure it has...

I love it. Sure it has bugs but it's the future and it aint going
to go away. We had already committed to SQL 2005 BI toolkit
for our main server set up so MOSS 2007 & Office...
17. ## Thread: my nickname is ... & my real name is ...

by WillR
Replies
65
Views
8,779

### WillR Will Riley I just hit "JOIN"...

WillR

Will Riley

I just hit "JOIN" before I finished typing my name I guess :huh:
18. ## Thread: Excel and web sites!

by WillR
Replies
6
Views
773

### Hi Greg, I have sent you a PM. :-D

Hi Greg,

I have sent you a PM. :-D
19. ## Thread: Excel and web sites!

by WillR
Replies
6
Views
773

### You could do this if you were using something...

You could do this if you were using something like Sharepoint - but only one user at a time would be able to have the file open & use the macros as with normal XL behaviour (AFAIK)

And all users...
20. ## Thread: Top 10 Excel applications

by WillR
Replies
21
Views
3,214

### As well as the other stuff listed here I used...

As well as the other stuff listed here

I used Excel as a database to chart my daughter's milk intake when she was born up until she was weaned - it was a cool little application and what made it...
21. ## Thread: Importing data using ODBC Database

by WillR
Replies
2
Views
481

### You can use the datalinks wizard ...

You can use the datalinks wizard

'*************************************************************************
'* The following code enables the user to get a valid connection string *...

by WillR
Replies
3
Views
461

### I'd say your assumption was pretty much spot on....

I'd say your assumption was pretty much spot on. :)
23. ## Thread: 1004 Method Range of Object failed

by WillR
Replies
3
Views
282

### Have you tried ...

Have you tried

Sheets("B").Range("A6:B6").Font.ColorIndex = 3
24. ## Thread: Sumproduct needs refinement

by WillR
Replies
7
Views
437

=SUMPRODUCT((YEAR('Powers Final '!\$E\$32:\$E\$600)=YEAR('Summary Final '!D62))*'Powers Final '!\$N\$32:\$N\$600)
25. ## Thread: Need to suppress prompt

by WillR
Replies
2
Views
339

### Wrap the code in Application.DisplayAlerts =...

Wrap the code in