Programming

Calculating age at different points in time
Using 2007, I need to calculate exact ages based on both full and partial dates that could range from the 1400's to current day. This is for a genealogy project. I would like to be able to enter a birth date into a cell which could be month-day-year if known or month-year if known or just year. In an adjace... 3 Mar 2010 18:41

Date VBA
Hi, I need help with a problem. I have a range of cells C6 to I6 tith the date in them Mon to Sun, below these cells I have input in some of the cell an X to mark the days a person is taking a holiday. so Wed, Thurs, Fri the cells below are marked with an X to indicate a holiday, what I am looking to do is... 3 Mar 2010 13:02

? Index of Names
Hi, I need some help with a query I have. I have a range of cells in sheet 1 and Sheet 2 as below Cell Range A1 to A4 J Bloggs M Smith R Scott G Thomson What I need to do is list J Bloggs on sheet 3 M Smith in sheet 4 R Scott in sheet 5 G Thomson in sheet 6 so in sheet 3 M Smith will be put into c... 3 Mar 2010 13:02

Updated Links
Can anyone tell me how to automatically update the hyperlinks in my excel doc upon opening or maybe once a week. The hyperlinks are web based. Thanks! ... 3 Mar 2010 13:02

toggle read only
I posted a q yesterday about this but was unclear in what I was after. What I would like is for the cells from A7 down to turn grey when the user toggles to 'read only' using the "Toggle read only" button on a tool bar. When the user toggles back to read/write, those same cells go back to unformatted. The first... 4 Mar 2010 07:51

Unhide Columns With A Password
I am trying to create a small marco that unhides a few columns in excel, but prompts for a password. Is this possible? Thanks ... 8 Mar 2010 08:36

rounding to nearest .5 in vba
i'm wondering if there is a single formula that will round the following examples in vba. i can do it with if statements, but looking for a more compact solution to enter the value in a cell. if it's < .5 it rounds to .5. if it's > .5 it rounds to the nearest .5. 4.571428571 5 0.571428571 ... 4 Mar 2010 08:58

Axspreadsheet datasource
Hi all, I am using OWC11 (AxSpreadsheet) control in my vb.net application. In that i need to display data from Mysql DB. This is my sample code to bind data to spreadsheet. AxSpreadsheet2.Worksheets(1).Cells.Clear() AxSpreadsheet2.Worksheets(1).Name = "Batches" AxSpreadsheet2.Worksheets(1).StandardWidth ... 3 Mar 2010 08:27

Split cells VBA
Hi everyone, I've been using the following (kindly supplied by Rick Rothstein) to split address items. Sub SplitCells() Dim X As Long Dim Z As Long Dim LastRow As Long Dim Sections() As String With Worksheets("Sheet1") LastRow = .Cells(.Rows.Count, "A").End(xlUp).Row For X = 2 To LastRow Section... 3 Mar 2010 10:41

Loop thru used rows in column
Hello, I am fairly new to Excel VBA and I need to know how to loop through used rows in a one column. In logic for each row in column A starting @ A4 to A whatever So I need to return values in A4-A whatever is used. I hope that makes sense Thanks! ... 3 Mar 2010 11:51