Type: Posts; User: Karat; Keyword(s):
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.
Helping someone with Visio. Is it at all possible to link certain processes with MS project ??
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...
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...
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...
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"
Do you get an error? If so, which and on what line of the code?
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...
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
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...
That worked just fine
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:
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....
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...
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...