Search:

I'd just like to add a me too. I only met him in real life a couple of times, but they confirmed him as a friend. I've not been around for a while, so didn't see his recent contribution to this...

Another option might be to ask <!profile=chrisgreaves>chrisgreaves<!/profile> if he has a tool that can do this or look on his website - I know he was working on something along these lines a long...

I've used Prettycode in a previous life (but only in excel) and it could do all modules in a workbook but I'm fairly sure it couldn't do all modules in all workbooks open - and I'm certain you had to...

Try Alt and Tab or Control and Tab - one of those should do what you want.

Brilliant - thanks for that. ( I won't be re-editing the SQL - It was already making my eyes glaze over!!!) <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

I have a database where some of the tables/queries in a query have been aliased. How do I remove the alias – or at the very least see through an alias to find out what it refers to – right clicking...

This works for me - I followed a link in a notification and the behaviour went away - I've now got two favourites, one which only shows the wopr domain and one which shows the real address - guess...

FWIW, this happens to me as well....

I had noticed that wherever I am in the lounge, the address bar always shows http://www.wopr.com/ - I assumed this was some sort of system setting (new...

These are error checking indicators - to turn them off go to Tools | Options | Error Checking and deselect "Enable Background error checking".

again, clutching at straws...

You say you're passing the SendTo in as a string. Have you tried passing it in as an array? Below is an outline of how I do it, but I've never gone for large...

I was going to apologise about the time-delay in replying, but I'm not sure that's necessary? <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

I was hoping that you could do it by...

Agreed. I find it curious that different people get different numbers, but I guess it is just that - a curiosity. FWIW, iseven and yield produce the same behaviour, but I doubt I'll be investigating...

are you suggesting i don't have it permanently running? <img src=/S/grin.gif border=0 alt=grin width=15 height=15> I checked with the version i had, and have just checked with the most recent...

Does anybody know why,if i type "=isodd" (no brackets - I was playing and hit the enter key too soon) in a cell, I get the result "-154468285"? another addin using this as a defined name perhaps (I...

It is possible - you've just got your brackets muddled. The following works for me:

=IF(OR(AND(A1>0,A1<10),AND(B1>0,B1<10)),"OKAY",0)

try changing the line "For c = 1 To c = 20" to "For c = 1 To 20" - any better?

<img src=/S/blush.gif border=0 alt=blush width=15 height=15> thanks for the catch...

Here's some quick and dirty code I cobbled together some time ago - there are probably tidier ways of doing this. I'm not sure, but the original source would probably have been either here, j-walk...

<hr>What's the difference between the two ?<hr>
Does this help?

yes, I experience the same - "this query returned no data..." - same excel as you - 2002 sp3

I hope <img src=/S/eileen.gif border=0 alt=eileen width=17 height=15> will let me off a "me too" response just this once, but everybody else has put my feelings far more eloquently than I could. A...

On point a:

I've never used it myself, so can only offer you the online help (for XP):


<hr>Open the Whiteboard in an online meeting
Only the host of an online meeting can open the Whiteboard...

add the line

Activeworkbook.Close

immediately after the .SaveAs line.

Change the line:

.SaveAs FileName:=ActiveSheet.Name

to something like:

.SaveAs FileName:= "H:FolderAFolderB" & ActiveSheet.Name

Steve,

a) I can't see any other statistical functions in the ID range 1 to 5400, so I think you'll have to roll your own.

/forums/images/smilies/cool.gif I don't think any of the boxes at the...