Search results for query: *

I have a numerical field "PM_Month" with 1 through 12 indicating the month a PM is due on a piece of equipment. Another field which is date format needs to hold the PM date for the current year using the month from the PM_Month field. I am attempting to use an update query to...

Rooster, There is a known bug in Excel 97 that does exactly what your problem is. If anyone or any of your VBA code is using SaveAs and specifying the SaveAs type "Microsoft Excel 5.0/95 Workbook" or "Microsoft Excel 97/2000 Workbook", The file will double in size. There...

You can input the first two cells with the 7 day offset. Then highlight both cells, grab the handle in the lower right corner and drag as far as you need. Each cell will then have a date 7 days later than the one befor it.

You would need to use VBA to change the header based on the page being printed. The simple solution would be as you suggest and add the additional text at the top of page 24 on your worksheet. To give you a blunt answer to you question: No you can't have multiple headers on the same...

Don't think so but there is a workaround. Insert a new column A and put the row numbers in that column. Then go to Tools>Options and uncheck "Row & Column Headers"

What do you mean by multiple headers? Give us an example of what you are trying to do.

Fish, Back to your original question: No it would not be hard at all as long as we know what you want to end up with and what data you have to get there. You should start with your final answer, e.g. How much did we make on this deal? This translates to a formula like: Profit = Sell_Price -...

It looks like what you are doing is purchasing leads for potintial travel sales. You want to know what your profit is based on the number of sales you made to those on the lead list. The way I read it: You buy 1000 leads at $1.00 each for $1000 dollars. You make 10 sales for travel packages...

You can send the workbook to me if you would like. I'll fix the problem and return it to you. Bob Crawford bobc@san.rr.com

Not a problem at all in Excel. Put the Cost in one column, the quantity sold in another column, and your formula using cell referance in a third column. It would help to know what your formula for item three is.

If you could show us the formula you are using we may be able to give you some idea where the problem is. If you expand the column that has the ######## in it you will probably see some kind of error message.

Try double clicking in the blue band at the top of the Excel Window.

Can you give us a real case formula you are using? What you indicated in your original message would not need any nested if statements. A complex formula can also me modified to take N/A into account without nested If Statements. We just need to know what you are trying to do.

Add something like & ActiveSheet.Name to the code that creates the text block for output.

One among many ways to find these links is under Insert>Name>Define. Scroll through all the defined names and delete those refering to the 'Other' file. You will see the 'Other' path and filename in the definition. If the 'Other' file is open you won't see the path.

Don't think it has anything to do with cable-modem. It has to do with the receivers email client. I know Lotus Notes on the receiving end has the problem. I'm sure others do also. I send HTML or Outlook RTF most of the time myself but not when sending to Lotus Notes Users.

Try a modification of tclere's formula using iserr(): =IF(ISERR(B4*C4),0,B4*C4)

Private Sub bActualToday_Click() On Error GoTo ErrorHandler With ActiveSheet.Range("a2:IS2") Range(.Find(Date, LookIn:=xlValues).Address).Activate End With ErrorHandler: ' Error-handling routine End Sub Me thinks you are attempting to be too cute with this code. You need the...

The code needs to be placed on the This Workbook modual using VBE.

Also check that your Normal.doc has not grown or is even there. Check your free space on the disk and clean up some files if needed.