Recent content by Tuff

Sorry should be more specific. I was wondering how the data entry box was created & linked to the actual spreadsheet?

Hi all, I recently found an old excel spreadsheet which contained a button which when pressed opened a data entry box. This data entry box looks like a standard windows box. (ie look and feel was similar to say windows volume control). The required data entry was for the key variables in the...

Thanks everyone, What I have ended up using is to worksheet functions in conjuction with one another. =(DATEDIF(firstyear cell address,secondyear cell address + 1,"Y"))+((DATEDIF(firstyear cell address,secondyear cell address + 1,"YD"))/365). As the date range is not always an even year.

Hi Guys, Is there a function or formula I can use in Excel to calculate the number of years between two dates. IE Start Date = 01/01/99 End Date = 31/12/04. I need the formula to tell me that is 5 years. (I am having a problem with the leap years).

Yep that did the trick. Thanks

Hi guys, I am sure it is possible to do this but I don't know how. I want to link a cell value to the macro. EG - Something like this. ActiveSheet.Select"Book2" Range("M13").Select ActiveCell.FormulaR1C1 = "Sheet"book1""C6" How can I go about...

Thanks heaps guys. Much appreciated.

Hi Guys, Just wondering if it is possible to link a macro to a cell value within a spreasheet. ie change the following: "\\finance\group\Accounts\TH\Uploads\MUP\2003-04\Nov03\M03105.xls" To say something like this...

Thanks guys all excellent suggestions. But I think I will used to the ActiveCell.End(x1Down).Select option. If you can't work smart, then you should just work hard.

Morning/afternoon everyone, I am writing a macro that needs to highlight and copy a range of data. However the amount of rows used varies everytime it is run, and I don't know how to get it to just highlight the data that is there. Similar to this except in the downward direction...

Thnks Geoff, Seems to be working well.

Is is possible to protect a worksheet in a way where it prevents a user from using the CUT & PASTE function. And if does this also apply to the COPY & PASTE function. Thanks

Ok got a bit of tricky on here. I have written a macro in excel, and it creates a sheet alters the data in it, and then delete the sheet. However when I run the macro it always comes up with the message box asking. The Selected sheet will be permantely deleted. To Delete the selected sheets...

Thanking you. Worked perfectly

Hi Guys I am stuck. I am using the find function to get a cell reference in an excel spreadsheet, but then I need to move up one cell (as it is the cell above the one it finds that I want to delete). I can get it go to the cell that I want it to find, but then I can get it to move one cell...