Search:

Type: Posts; User: Mexcel; Keyword(s):

Search: Search took 0.00 seconds.

  1. Re: Method to back up a file on a specified time

    As much as I like Excel I recommend you use a backup program yourself. Most backup programs can do regular backups. If you insist on using Excel you may want to try the Ontime() procedure to copy a...
  2. Need smarter solution to get the name of a name...

    In a worksheet cell I want =NameOf(MyRangeName) to produce a string that is "MyRangeName". (While MyRangeName is a defined name that refers to e.g. =Sheet1!A1)

    This works:


    Function...
  3. Re: Adjusting comment placement when scrolling over cell.

    Darren,
    This will do the trick:


    Range("D1").Comment.Shape.Select
    Selection.ShapeRange.IncrementLeft -155
  4. Replies
    6
    Views
    629

    Re: Summing Duplicates in column B

    Charlie,
    You could:
    1. enter the formula on a different sheet or workbook that does not get deleted;
    2. re-enter te formula with the help of VBA when needed, then read the result back to VBA....
  5. Replies
    6
    Views
    629

    Re: Summing Duplicates in column B

    Charlie,
    You don't need a Macro for this. Simply combine the cells into a single string in a free column J. F.e. in J2:

    =C2&D2&E2&F2&G2
    then in cell B2 you put

    ...
  6. Re: How to create a macro to add a new worksheet and rename it.

    Try this:
    <CODE></CODE>
    <CODE><CODE>
    Application.DisplayAlerts=false </CODE></CODE>
  7. Replies
    18
    Views
    68,451

    Re: Amortization 360 vs 365 Days

    Your banks payment is equivalent to an AER of 6.264%. Now I can get pretty close to your banks payment with ((1+6%/360)^(365/12)-1) as monthly interest rate on the outstanding balance. This is of...
  8. Re: VBA function calling from horizontal or vertical range?

    Thanks PGC. Was indeed looking for the application caller property but like the matrix with ones solution even more.

    I am not sure if this is the easiest way to create matrices with ones of the...
  9. Re: VBA function calling from horizontal or vertical range?

    Thanks Phil. I tried it but indeed it only works when the function is entered as array. After that the selection is different and it all becomes the same as the sum of the columns. I believe there is...
  10. Replies
    2
    Views
    348

    Re: more than 3 conditional formats

    It is indeed possible to write a VBA function to get the cell color. You would need to google to find it.

    Office 2007 would be your best option since that can handle much more conditional...
  11. Replies
    1
    Views
    339

    Re: Linking and macros

    The link to the picture is dead but try =SUMIF(...) in a worksheet. Excel help will explain how that works.
  12. VBA function calling from horizontal or vertical range?

    The function below sums up columns of a matrix and the result is a horizontal array. Now I would like to modify that function so that if the calling range is vertical that it returns the sum of the...
Results 1 to 12 of 12