Search:

Hi Bruce and Ted,

I would love to give you a picture, but the Windows Snipping Tool on this Vista machine does not allow me to copy a screen showing the Favorites drop down menu. The menu...

Hi Ted,

Thanks for the reply.

I am talking about the second picture you displayed.

The first column under Favorites is always displayed when Favorites is clicked!

However some of the...

Hi,

My pet IE annoyance.

I use IE8 and IE9 on different machines, and on both I regularly find that when I select the Favorites menu, I cannot select any Folders which I have setup under...

Hi,

If you want to do something more sophisticated than a simple Find and Replace then check out the following:
...

Hi,

You were absolutely correct.

It seems I have a problem installing Flash on my PC.

Will have to investigate further.

Many thanks.

Hi,

I have IE8 on a Windows Vista PC.

Today at http://apod.nasa.gov/apod/ (Dec 15) there is a picture/movie I am unable to view.

It just displays with the frame and a miniscule icon in the...

Hi,

You could not go past Jonh Walkenbach and his books at:

http://spreadsheetpage.com/index.php/books

Good Luck!

Peter Moran

Hi,

Easier than you think!

Just setup a new workbook just as you want it and then save to the XLSTART folder as book1.xlt.

To do the same for when you inset a new sheet, set it up as...

Hi,

Checkout this URL at the ExcelTips website for a macro to do it for you:

http://excel.tips.net/Pages/T002219_Printing_a_Single_Column_in_Multiple_Columns.html

Good Luck!

Peter Moran

Hi Rory,

Thanks for your update - no complaints now - all is working as it should!

And thanks to RetiredGeek for his input.

Also I found this interesting post on the Ozgrid site:...

Hi Retired Geek,

I am using Excel 2K.

I loved your Relative Sheet Reference UDF as soon as I saw it!

I have tried to implement it but am having problems in that whenever I go to another...

Hi,

A simple test in XL07 indicates that the following format will work provided, I think, that the other spreadsheet - Book2 - is already open in the same instance of Excel.

In Book3.xls, the...

Hi,


This code is from an OZgrid (www.ozgrid.com) newsletter. It may be of use if you can use macros/functions.

I have not used it myself, but would be most suprised if it did not work.


...

Hi Jefferson,

Have updated the code with where the error occurs.

Was there originally but lost in an update.

Regards,

Peter moran

Hi,

This code is calculating and formatting the difference between two dates in actual days and working days:

The code below works fine in Xl2K but in Excel 07 it gets the following.

Type 13...

Hi,

What about showing us the macro?

Much more likely to be able to help then.

Peter Moran

Hi,

I would also add:

http://blog.livedoor.jp/andrewe/

Peter Moran

Hi,

You can have Ranges defined on each sheet in a workbook so that the range is only known in the specific sheet.

One of the handy features of Excel is that you can define names that refer to...

Hi,

Thanks Hans and Jan.

At least you confirmed my initial thoughts that there was no easy way I was overlooking.

Also found Jan's other thread you referred to most interesting.

Have...

Hi,

I have an unsorted list of placenames to enter regularly, and I would like to be able to have an alphabetically sorted listing available by formula as the data is entered, such as Ranking for...

Hi,

For what it is worth, if people are not all using the same printer to print the report then it is possible that the problem may relate to the way some printers are setup, or how they are setup...

(Edited by HansV to make URL clickable - see <!help=19>Help 19<!/help>)

Hi,

Checkout Martin Green's VBA site:

http://www.fontstuff.com/word/index.htm

You will find exactly what you want,...

Hi,

What about selecting the range, and then typing the name into the Name-box on the left of the Formula Bar. Who needs INSERT NAME DEFINE???

Or am I on the wrong wavelength completely?
...

Thanks again Hans.

I can now see the distinction.

Regards,

Peter Moran

Thanks Hans,

I guess I should never have expected that Copy and Paste in VBA would be identical to what happens using the keyboard and menus!!

Such is life, such is computing!

Peter Moran