I'm trying to set up condition of to var. exp( if var1=empty then var2=0)

Hi all, When I apply text wrap to a cell, the width of the column
determines how the wrap is handled. I want to have a short list in one
cell, and start new lines within the cell for each item in the list. I
have discovered that if I write the list in Word, then paste it into

I keep getting a "formula can't calculate" error in one of my workbooks.
The only problem is every formula is calculating correctly.
When using Advanced Name Manager, I'm able to see a named range that looks
like _xlfn.IFERROR with a value of = #NAME?

I would like to do the following with excel Formula.
these are the information
Sheet 2
A               M

Scenario:
Word document from page 1 to 40.
Excel File with Sheets 1 to 40 (so there are 40 sheets)
What they want is each sheet to be printed alternatively after the pages in

I need a macro (VBA Code)  to:
1- unprotect sheet with password="111"
2-  HIDE empty rows between 7 and 159 (7, 159 are included)
3-  Print the range A4:D160

does somebody know a software that can make a doubleclick on a certain cell
for me? This action must be fired by Excel VBA code.
Until now I found eg.
http://www.tethyssolutions.com/download-aa.htm

Could someone help me out with the following:
I would like to lookup IR00202PH in column A and subsequently check if
column B contains an "S" and column C contains "FIXED". If both
lookups are true, then again lookup IR00202PH in column A and retrieve

Hi all, thanks for any help you can provide.
When using a pivot table, I some times filter out a specific entry by
un-checking the drop down menu on a row field. I have noticed that there is
data stored on this drop down lists that is no longer in the source data.

Can you have a look at this and please tell why it doesnt work
Sub CopySheetAsHTML()
Dim fName As String
Dim wks As Worksheet

After installing my Excel 2007, I encountered a quite strange problem :
Opening a new document has actually no problem but ! if I open an existing
Excel file nothing happens, I see no sheet. I need to double-click on the
file (or minimize the window) to make my sheet appear.

I want to set up a multiple year callener for Jule to June also with weeks 1
to 52 . Is it possible and can you help or just send me a templete.

I have a summary worksheet with several columns of information.
There is one particular column (E25:F39) where I don't always want to print
the values.  Is there some simple way to toggle this column's values on and
off just before hitting the print command?

in our company, standard working time is 07:30 (or 7.5) hours per day.
i would like to know can i convert working hours during month as man.days ?
e.g.: if someone worked 15 hours = 2 man.days.
format of cells where daily hours are written is : hh:mm:ss

When I try and insert a row I get a prompt saying
"To prevent possible loss of data, Excel cannot shift non-blank cells
off the worksheet.  Try to locate the last non-blank cell by pressing
CTRL+END and delete or clear all cells in between the last cell and the