Search:

WOW thanks...

Hi there
I have a simple question that just doesn't seem to work in excel 2007.
In column B I have 2 words - either Show or Hide..
When it is "Hide" the rest of the row turns into white font.
...

HI there
Helping someone with Visio. Is it at all possible to link certain processes with MS project ??

Help appreciated

Cheers
Karat

Hi there
I have to change lots of cells which have existing formula and changing them with numbers.

Is there a way i can have the cell on the right change when the cell in for instance A1...

Thanks

Hi there
I'm not really a Word wiz and kinda struggling at the moment.

I had to change a document and I've put fields in it. No problems there. But one of the users has to copy an paste certain...

Hi there
Thanks for all the help.

I have actually taken a bold move and disconnected my desktop. Last Saturday it did it again and I just couldn't take it anymore. I was extremely close...

The manufacturer is ASUS. The local shop is very helpful but can't find the problem. It is so very stressful. I'm reluctant changing over to windows 7 as it doesn't seem to be a software problem. I...

Hi there
I run XP service pack 3. I now have my 3rd computer in as many months. Only software I have on it is Office, Eudora and mail washer. I can't be bothered loading the rest.
When I got the...

Yes, the line is

oCell.EntireRow.Hidden = True

and the message sayd "Run-time error 1004 - Unable to set the Hidden property of the Range class"


Thanks

Do you get an error? If so, which and on what line of the code?

Hi there
I have written a macro and on the workbook I have on my machine it works great - macro below - however, my client has problems, so he emailed the workbook back to me.
He opened it in 2007...

Hi there

I have this spreadsheet with columns and columns of data. The data is transferred into graphs. The columns are 3 years (36 months) but the data I use for my graphs are 13 months. So at...

I have been struggling with this. I have attached a small part of the spreadsheet.
It shows red where there is nothing, which at least is a start :)

Thanks so much

Hi there
I'm struggling a bit with conditional formatting (and it should be fairly simple)
I have a list with dates..
I want the dates that are late shown up in red

Today (March 17) should show...

Thanks heaps
That worked just fine

Cheers

Hi there
I have exported a large database into excel.
There are several columns with dates and what ever I do they stay the same - for instance 1/10/2009 will never be 01/10/2009.
Because I use...

You can make the definition of the named ranges AA, BB and CC dependent on the user's choice in row 7. For example for AA:

=OFFSET(Sheet1!$A$17,0,0,1,IF(Sheet2!$D$7="….",1,5))

See attached...

Hi there
I'm probably overlooking the obvious but I have a question.

Sheet 2 row 7 people have to select a Type (dropdowns) and when they only have Type A and B they select "..." where C is....

It worked...
Have no idea when it didn't work before when I copied and pasted your formula, but now it works, so thanks heaps...

PS where you from being online at this time of day ?? Usually its...

Nothing happens, no background colour, it stays white

Thanks for your help but it didn't work. I've tried all options.. I'm sure I'm missing the most obvious...

Thanks anyway

Hi there
I have this macro and it works great, however, my manager (in his ultimate wisdom) has decided to change numbers to letters, and I've tried making changes myself but it doesn't seem to...

Thanks everybody....

Thanks heaps