Search results for query: *

You may be able to trackdown the current user paths using one of the environment variables. USe something like this to discover the correct variable Sub PrintLocalSettings() Dim I As Integer I = 1 Debug.Print "Local Settings in force are:" While Environ(I) > ""...

The =SUMPRODUCT() command should work here. Something like this will work in E2 =SUMPRODUCT(INT(E1='Maze 1'!$A$2:$F$2), 'Maze 1'!$A$3:$F$3) This formula should work for the whole of column E, you will need to update the 'maze 1' refernce for the other columns. It is possible to do this...

Instead of deleting the data in 'Month', use the option 'clear contents'. (From the edit menu) Deleting the cells can oftentimes screw up formula cell references as the reference to the formual is being deleted, therefore the #ref error. Kieran

If you enter dd/mm in the cell, excel will assume the current year for you when it displays the date. Anything more than this default behaviour will require a macro. A macro like this could be done, but it seems to be overkill when all you need to do is enter the additional month. Kieran

As explained in http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=xl&Number=96294&page=&view=&sb=&o=&vc=1 If you have templates called Book.xlt and Sheet.xlt in the XLStart directory, they should provide the default settings without the need for VBA or macros at all. If the book does not...

I use the following function. It needs to be added to a module within the workbook or your personal.xls file (i it exists) 'Here is what I use, it works for up to Sextllions. It will also give you something like 'Three Hundred Thirty Dollars and Sixty Seven Cents if you pass it the optional...

ctrl-r will apply right justification.

Try this additional step, it may make my previous advice redundant. Look at Tools>options>view>display zero values checkbox. Ensure that the checkbox is set. That may toggle the view if there is 0 in the cell. If the cells is empty, I cannot find an immediate soultion other than filling those...

Try [hh]:mm:ss. It will give you two zero's, but it may suffice

try this Option Explicit Function MYPIC(source As Range) As Object Dim PATH As String Dim FILE As String FILE = source.Value PATH = "X:\PICTURES\" & FILE & ".JPG" ActiveSheet.Shapes.AddPicture PATH, True, True, 100...

If you customise the query to take parameters, you can specify the parameters in excel and then query the external data. Do this by creating the query in MS Query with the parameters. Then run the query form excel, right click in the returned data and select parameters. You should be able to...

Use the =countif(....) function. Help describes it quite well.

Without knowing the finer details of your process I can only suggest that you use the application.enableevents= false before you load the data then use your code to trap for the error, then set a timer to repeat the load after a one minute interval. Don't forget to set application.enableevents...

Are you using word, Access, Excel. If access/excel I would suggest you create a list of all the possible dates in a year (only 366) do a lookup based on the day/month. If you are in word, I can't suggest anything off-hand other thtn use access/excel.

Try a formula like =if(a24-b24=0, "X","") This assumes that the data starts in cell a24. Enter the formula in c24 and copy down for the lenght of the list.

this is untested, but 'should work' =AE7+($AH7=1)* ($AF7+($AK7=1) * ($AI7+($AN7=1) * ($AL7+($AQ7=1) *( $AO7+($AT7=1) * ($AR7+($AW7=1) * ($AU7+($AZ7=1) * $AX7)))))) It relies on the fact that the test xxx=1 will return either 0 (false) or 1 (true). It is an implicit if statement I suppose...

You can use the if field to do some thing like {if {page} <> {numpages} &quot;more..&quot; &quot;&quot;} You will need to use the insert field function for the if, page and numpages field as the &quot;{}&quot; are not able to be pasted.

I have seen it doen with an add-in crated by Ian Sharpe. I have customised it a bit, but the following work is basically his. I have not used it for some time, but I beleive that it is workable, however to remove an itme still requires that you use the toolbar customeise command I think, THe...

It involves a little bit of set up, but have yo thought about pivot tables. Data entery will not involve any recalculation, however everytime you want to review the results, you will need to refresh the pivot table.

...lRowCount = 1 To lInRows If lRowCount Mod 100 = 0 Then Application.StatusBar = &quot;Completed &quot; & Int(lRowCount / lInRows * 100) & &quot;% of duplicate analysis... &quot; Application.DisplayStatusBar = True End If lOccurCount = 2...