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).
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...
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...
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...
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...
Hi everyone,
How do I get my cursor to move up or down cells in Excel.
I don't want to move to an exact cell reference point. I want it to find a certain value within the spreadsheet, then move either up or down one cell.
Can I do this?
Thanks
When writing a macro is it possible to use the find function to set your cell reference.
IE. To find the cells that need to be selected, I need to use the find function, as the cell position I need changes from G23 to G35 to G189 etc etc everytime.
Once I find the cell I simply need to select...
J would like to know the solution to use foxpro 2.6 with
Active Data Object, because j can't open my database with
ADO, j have tried to use Dbase driver but j have no success.
thanks for your help. Rico
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.