Search:

I find if I post a new thread - it takes my paragraph marks out and three paragraphs become one. Others can put in paragraphs - what am I doing wrong?

Sorry - we have it...
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,256)

I have been asked if it is possible to show the name of the tab in a cell (NOT in the header or footer). I have found ways to put the name of the file in a cell and HELP shows how to put the file...

When we run a macro here it works fine, the variable i is replaced each time the macro jumps to a new sheet. However, when we try and step through the macro - the variable does not seem to be...

Do you mean that you perform a mail merge to e-mail in Word, with an Excel worksheet as data source?

Ah...I think I found it...

Date formatting in Excel is a property of the cell containing the...

When I merge from Excel to Outlook I get a U.S. date format in Outlook. I have tried formatting the date and even pasting as text but each time Outlook shows it in U.S. format. How do I get the...

Can you use Voting buttons when doing a mailmerge to outlook? Outlook 2003.

I was afraid that might be the answer. Thanks anyway.

Neil

Is it possible to perform a mailmerge and have the mails sent out have voting buttons on them? I cannot get it to work.

Nice one. Thanks

I want to jump to the next sheet in a workbook after running some code but will not know what the name of the worksheet is. Having jumped to the next sheet I then want to run that code again until...

Excellent - thanks again.

Another great tip! I will add this to my growing list of what to check for. One question; You say if we have code that points to row 65536 or column 256 (IV) we may want to change it. Presumably...

Very useful, I will include that tip in our information to our staff.

Great. Thanks for the quick reply

We are about to upgrade to Office 2007 from 2003 and have loads of Macros that have been written as well as recorded. Are we likely to suffer greatly when opening these old spreadsheets?

Thanks Hans. I had try to create a hyperlink but that was no good as it kept giving me the warning message about opening applications from a link - but I never thought about action buttons...
...

I need to mix Portrait and Landscape pages in a show. Is it possible?

Well deserved. It is people like you guys that make my life so much easier.

Neil

Wow. I have seen stuff from this guy before. Very good.

Thanks for that.

I have a user who wants to add a clock to Excel! I have shown him the =Now() function but he wants more than that - he actually wants a clock in Excel. Anyone got an example?

Thanks. I did look in help but it does not mention People's Calendars at all. I have included a screen shot to show what I mean about having three places to put calendars.

Neil

I am trying to get documentation sorted for my people on the differences with the new 2007 versions of Office. Outlook has My Calendars, People's Calandars and Other Calendars. I can add things to...

Brilliant! Thanks

Neil

Where did it go? In previous versions you could hold down shift and click on File and you would get Close All instead of just Close. Great!

Where did it go in 2007. I have tried every...