Recent content by TenBellie

That's great really appreciate the help works a treat sorry for my bad explanations

Sorry if it wasn't clear...not very good at explaining stuff! I'll try again... A fault is reported on 01/2/2014 07:23 (this data is the same cell A1) The fault is cleared on 03/02/2014 15:00 (this data is in the same cell B1) I need to be able to calculate the elapsed time diffrence between...

Hi, Can anyone help me work out a formula in excel to calculate time diffrence when part of the window stops.. EG Flt reported 07/03/2014 12:55 flt closed 08/03/2014 13:30 The clock stops between 01:00 and 8:00 so this time is not part of the duration to fix the flt... I have many rows of...

Hi = thanks fopr you help i have worked out how to run it... Public Sub Column_Hide() Worksheet_Change ([a1]) End Sub Public Sub Worksheet_Change(ByVal Target As Range) Dim rFound As Range Cells.EntireColumn.Hidden = False If Not Application.Intersect(Target, [a1]) Is Nothing Then...

I am not adding it to any other code i cant get it to run unless its under a user button. There is no other macros in there

I am placing the code in an active X command button, the old code i placed under a Form Controls command button. I cant fine the new code under the other form option hence the active X. However i now get a new error says = Ambiguous name detected: worksheet_change

Sorry i know i'm a pain and i do really appreciate this but still has an error... same error code the line is the same place it fails If Application.Intersect(target, [A1]) Is Nothing Then

It has a run time error '424' object required The row "If not intersect(target, [A1]) is nothing then" is in yellow when i press de-bug

They go in consecutive order (merged cells D, E & F, - G, H & I etc abouve header row saying Ammount Paid - AM - PM) Wed 05 Sep 12 - Thu 06 Sep 12 - Fri 07 Sep 12 - Mon 10 Sep 12 - Tue 11 Sep 12 - Wed 12 Sep 12

It changes it to 41289 when i change it back it goes back to the 15/01/13

The data is sorted in Surname order - currentlly i have 200 children registered but this is growing Row 1 Is where the dates of the week are - if i format them they go to numbers. I have them entered as dd/mm/yy Row 2 is the header row Christain Name is in cell A 2 Surname is in Cell B 2...

Sorry... I would like to print columns a,b & c, and also print any other 3 consecutive columns based on a date i manually type into cell A1. The date match would come from from cell A1 aligning to the date in AA1, or ZZ1, etc. Tried to show it below - Column A manually type the date in row 1...

Thats what i am doing manually every day - then unhiding and re-hiding etc as i said was just hoping some cleaver person could show me a code that would help make this easy with teh click of a button.... i can record a macro but with columns being diffrent every day it only work the day i...

The logic? Its for a school out of hpurs club. I have to print names attendees for a register to make sure everyomne attends and no child is missing (5-8year olds) The pupils names are in A and B, class number in C. In the other rows D onward are AM or PM attendees. I have to keep the whole...

Thanks but AA would only be for today, tomorrow it would be Ab, then Ac etc