Search:

Rory

Thanks for the reply - I use this as the cells in the selected columns contain a list that is cut off if the column width remains the same - any other thoughts?

Rory,

Thanks - I'll try to replace the vlookup's and see how it goes

Regards

Legare - Thanks for the reply

The only code it contains is below used to widen colums

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Static lngCol As Long
If...

Thanks for the quick reply Hans

I'll give it a try - I'll also try to strip down a workbook and post it if you can have a look

Longers, I have a spread sheet that is not very big (in terms of data), but it is very slow to insert/delete rows or columns or add copied tabs - like 5 - 10 minutes each

It uses mainly lookup...

Doc thanks for your help - will give it a go

Thanks again for your help

Complements of the season

Hans,

What happens is training (or as I call them "Must do Units") requirements vary from site to site - different work locations

In the planner I select the site, the position and the "Must Do...

Hans,

Thanks for the quick response - Please see sample attached

Loungers

I have the following formula in a conditional lookup - =OFFSET(course:Position,MATCH($E7,Position,0)-1,MATCH(F$6,course,0))="E"

I need to add a third criteria called site - so that the...

I have a folder on my desk top that I can rename but not delete. When I try to delete I get this message "Error deleting File or Folder - Cannot delete file: Cannot read from the source file or disk"...

Lounger,

Just toying with an idea to trigger an email reminder from a calculation within a spread sheet. The calculation indicates when a activity has "One Month Left" before it expires and then ...

Thanks Steve - thats it

Regards

Mbarron

I tied your formula - works fine except that it also put the TEXT value in front of "Action Underway" so I get "$123 is Action Underway". This is part of the problem I was having where...

Thanks very much for the reply - will give it a go

Regards

Hi - I have the formula =IF(H6<>"","Complete",IF(DAYS360(G6,TODAY())>0,DAYS360(G6,TODAY())&" days overdue","Action Underway")) with calculates the days past a date.
It works well except when there...

Hans, Steve

Thanks for your assistance

Thank you all for the quick responses.

Your assistance is much appreciated

Lounger's,

I have a spreadsheet sent to me where the person displayed the date as YYYYmmdd - ie 20060126. I'm trying to convert to a more recognised date format -ie dd/mm/yyyy - 26/1/2006.

Any...

Hans,

Thanks for the quick response - again.

Will give your suggestion a go

Lounger's

I have a number of basis shapes containing cell references to cell with conditional formatting - I can get the reference cell value but not the conditional formatting

Is there some...

Stuart,

Its amazing how you can miss the obvious! Thanks

Loungers

I'm trying to get the RDC to work on my home network, however when I browse to available computers, I see MSHOME but when I click on it I get a message "The MSHOME domain/workgroup does...

Thanks Phil and Rob - will give your suggestions a go!

Thanks - I'll give it a shot