Search results

Tools > Options > View > Sheet Tabs

Day() works on a serial number, which gets interpreted as a date (or date and time). So when you say you use "=Day(Sunday, March 04, 2007)" you should just get an error. I don't know how you are getting anything but an error. If you have a serial number then the cell must be formatted as "dddd...

And do what ? If you don't want the shared access you want dumping out without a spreadsheet ? If you do then you will just have read access and won't be able to save the file. So what are you trying to acheive ? With code (run from where ?) you could ingnore the message and just have read only...

Well you could try entering it once but the array won't work then. There are two terms here, the first determines if the individual values are greater, or equal to, 30 and the second passes values such that they may be averaged. This is an array formula (comitted with Ctrl-Shft-Enter). If you...

Normally when you specify the database connection you supply (if necessary) the username and password. What are you running this from and what are you connecting to ?

Sorry, what is your question ? What I normally do is use the tickcount, you get the tickcount, you run your code, you run a gettime procedure to subtract original tickcount from now and that gives you a figure in milliseconds, which I normally multiply by 1000 to display in seconds e.g. "2.372...

Is it a particular column you have a problem with or is it a set of columns ? Please list them. You can have a macro run EVERY TIME a workbook is opened so it doesn't matter who or what opened it last time. From what I recall AutoCAD will just write the file (i.e. a new file every time) so this...

You have two problems here. 1. You can't save an Excel sheet with a "20070423" type extension 2. Once you have saved the file as a text file (it saves as say :- "Pos.txt.20070423.txt") you then can't rename it without closing the file. It would be so much easier if you wanted (say) :-...

You can type in the imediate box :- ?Selection.Validation.Formula1 Which will print the validation list for the currently selected cell to the imediate window I could also write you a UDF (User Defined Formula) to allow you to enter say =ValListGrab(A2) to have the same written to a cell :-...

Yeah you can do this but it sounds like you'd need code to run it. How big is your user table ? Is it just 1 Column ? Is it listed Alphabetically ? or is it on 'time with company decending' ? If you have new employees, you say they go to the bottom, if the list is not sorted on 'time with...

-4142 is the colour for xlnone (i.e. no colour) The workbook colour ranges are determined by what the user has set (i.e. the user can displace colours out of the standard pallet) There is a standard range of colours but you should be aware of the above. The 'Standard' colours are :-...

Sorry, but Excel is not very secure, anyone with a hex editor could undo that (or if they spent some cash just use a password remover) The best option would be to run your code from another workbook such that only the data is contained in the book you distribute.

You could also use an Array formula =Average(if(range>=30,range)) but I'd say the answer given in niallc's post above is the best (and fastest) option

If you can tell us where the output goes or better still give an example file, then someone can cook up some code for you.