Search results

Activeworkbook.SaveAs "myfile_" & Format(Date,"yyyy_mm_dd")

See http://www.xldynamic.com/source/xld.xlFAQ0004.html

Another way if you are happy with a calculated column =--TEXT(SUBSTITUTE(A2,".",":"),"hh:mm") and format as hh:mm

Screws it up, in what way? Does it mess the numbers, or just leave it as text?

Do a Find & Replace (ctrl-H), and replace . with :

Create yourself a picture with your required text in it and embed the image on the form.

I have posted an example at http://dl.dropbox.com/u/4911716/SplashScreen%20-%203%20-%20Fading.xls

If you are going to use With, might as well use it throughout <br /> Set objXLApp = CreateObject("Excel.Application")<br /> With objxlapp</p> <p> .Visible=False<br /> .Workbooks.Add</p> <p> With .Activesheet</p&#62...

If you change A22 to say A123, you will see that your formula in returns 9, which is the 3+4 for D76 and D78, but also includes the 2 for A123. The OP never said every other row would be blank, just that there might be some interspersed blanks where the value was contained.

You don't have 1 cell less, it starts 1 cell earlier and ends one cell later. That is so that it can check 2 rows in the same set of tests.

Ry this =SUMPRODUCT(((LEFT($A$12:$A$200,1)="A")*$B$12:$B$200)+(($A$12:$A$200="")*(LEFT($A$11:$A$199,1)="A")*$B$12:$B$200))

Try =SUMPRODUCT(--((LEFT($C$12:$C$1000,1)="C")+($C$12:$C$1000="")),$D$12:$D$1000) etc.

Be aware that this will not cause an automatic recalculation, but it can be forced by adding something like &TEXT(TODAY(),"") to you formula.

Try =SUMPRODUCT(--(ISNUMBER(MATCH(B1:B3,A1:A3,0))))

<br /> Activeworkbook.SaveAs Filename:=Range("A1").Value<br />

Do you mean you want to select all cells with data in it? <br /> Dim rng As Range</p> <p> Set rng = ActiveCell.EntireRow.SpecialCells(xlCellTypeConstants)<br /> MsgBox rng.Address<br />

Can you post a workbook to look at?

You would need VBA for that, and you could maybe use regular expressions to check for ASC(<32). But beware ... Some people, when confronted with a problem, think "I know, I'll use regular expressions." Now they have two problems. ~~ Jamie Zawinski

change RefersTo of brdate to =OFFSET('BR 8-14'!$D$3,0,0,COUNTA('BR 8-14'!$D:$D)-COUNTA('BR 8-14'!$D$1:$D$2),1)

How about =ABS(prevQtr-thisQtr)/100

Show us what you have, and maybe a data sample.

Can you post some sample data so we can see what it looks like?

Exactly Hui, I despair of the self-centredness of such people thinking we are all just here to be at their beck and call.

This guy has cross-posted this at ExcelGuru http://bit.ly/em05qF

Just use CF with a formula of =C5-K5>100 and format as required