Programming

Compare worksheets
I have the Compare addin, and very useful it is too, however it does not go quite far enough because, as soon as it encounters an added or deleted row all subsequent rows show up as being "different". Technically this is correct, but what I really want is for the compare to notice that a row has been added (or dele... 11 Mar 2010 12:19

Freezpanes address - apologies for incorrect post
Hi all, In VBA, is it possible to determine the address at which a sheet is locked? I found a property activewindow.splithorizontal and splitvertical but they give me double length integers. Anyone know how toconvert this int an address? Kind regards, Bony -- "There are 10 types of people in this worl... 11 Mar 2010 12:19

Simple shared code library, also how to find spreadsheets with macros in them
Hello all! I started learning Excel VBA scripting informally a few years ago, and have been putting together increasingly complex utility scripts on an as needed basis. I've now gotten to the point where I've rewritten this stuff enough that I'd like to collect and modularize some of this code in a more reusable... 12 Mar 2010 00:42

Saving files automatically
Hi, I have a macro to save a number of different versions of my file for different budget holders. When this is run, it recognises that the file already exists and prompts to allow it to be overwritten. Is there some VBA I can add to accept the prompt automatically? Thanks Richard ... 11 Mar 2010 08:55

Message box warning of missing data
Hi, When a user inputs data (numbers) into cells in column D, they should include a three digit prefix before the numbers. I would like a message box to pop up if they fail to do this and delete what they have put in the cell thus forcing them to try again. For example 09/123 would be rejected but SUM09/123 wo... 11 Mar 2010 10:03

Replace Worksheetfunction.ln code
Morning, I want to replace the code "worksheetfunction.ln" with "math.log" in my code. Is this the same calculation? If not what piece of code should I be using. Thank you very much for your help, Michelle ... 11 Mar 2010 12:19

Select range from ActiveCell do to Lastcell
From Leith Ross 2/7/2006 Dim EndCell As Range Set EndCell = ActiveSheet.Cells(Rows.Count, "A").End(xlUp) ActiveSheet.Range(ActiveCell, EndCell).ClearContents If I change the A to an N it selects a range from ActiveCell down to last entry in Column N. My ActiveCell is in Column A but Column N may not have... 15 Mar 2010 04:37

Select specific worksheets & copy - code problem
Hi All I've tried to write the following code to: - find worksheets in active workbook with "Planned" in cell A1, - then select all those worksheets and copy them into one new workbook - then format each sheet within the new workbook (e.g. select a named range & copy/paste values etc) The workbook and workshee... 11 Mar 2010 06:44

Pasting to Cells to the Right.
A sheet contains AC NO, DATE, and Amount of Clients. 116530 17-Feb-10 2000.00 39361 17-Feb-10 300.00 40236 18-Feb-10 350.00 10563 18-Feb-10 100.00 116530 19-Feb-10 250.00 Ac Nos are names of the excel workbook (116530.xls) located at D:\conference\ AC No Workbook looks like this. A Date, B Time, C Country... 11 Mar 2010 10:03

Find if value does not exist in range.
... 10 Mar 2010 17:35