Search:

Type: Posts; User: alan sh; Keyword(s):

Page 1 of 9 1 2 3 4

Search: Search took 0.03 seconds.

  1. Thanks all. Very interesting stuff. I modified...

    Thanks all. Very interesting stuff.

    I modified RG's original to give me back the row and column number and it works great.

    However, don't pass a range that is all the columns or it will loop...
  2. Yes, I gathered that (later on). Cheers ...

    Yes, I gathered that (later on).

    Cheers

    Alan
  3. Thanks both - I like both answers but I have no...

    Thanks both - I like both answers but I have no idea why SUMPRODUCT works. Also, Maud, your text doesn't quite match the formula - the value is in B1, but your formula has $A$1 in it.

    Alan
  4. Is there a version of "MATCH" that works with multiple columns?

    Hello experts,

    I have a 2 dimensional array of bits of text. I want to find the row and column of one of those bits of text.

    I thought MATCH would do it - but that only works if you have a...
  5. Humm - I tried that code and it didn't like "cn"....

    Humm - I tried that code and it didn't like "cn". I just did a cut and paste (replacing semi colons with commas)

    Alan
  6. Cheers - will do

    Cheers - will do
  7. And here is the final code

    Thanks to RG for his input. If anyone wants to use this, feel free. If you wish to modify it (maybe add hours, mins seconds etc) help yourself.

    The code will check if a directory called "backup"...
  8. Cheers RG - your code works fine. Alan

    Cheers RG - your code works fine.


    Alan
  9. Thanks RG. I did find that article and applied...

    Thanks RG. I did find that article and applied it.

    My code looks like this, but for some reason, it posts the message box twice - no idea why though - any clues?:

    It also asks me if I want to...
  10. Change the default behaviour of the "save" button?

    I have a spreasdsheet - when a user clicks on "Save" (or does it from the menu), I want my macro to be run instead (it will add the current date/time to the end of the filename to force a sort of...
  11. I think a right click context menu is what I am...

    I think a right click context menu is what I am looking for too. But not from within Excel. If I have 3 excel workbooks and I want to open them in new instances of Excel, is there a way to add this...
  12. I use ...

    I use

    =if(isna(vlookup(....)),"",vlookup(....))


    Alan
  13. Thanks. I like that idea as well. I'll play...

    Thanks. I like that idea as well. I'll play tomorrow.

    Alan
  14. That works fine. Thanks.

    That works fine. Thanks.
  15. That looks good. I'll try it. Sorry if I was a...

    That looks good. I'll try it.

    Sorry if I was a bit vague. I think you caught what I meant though.

    Cheers

    Alan
  16. How do I position graphs next to a cell in VB?

    I have macro which builds a bunch of tables and then produces graphs. I want to position the graphs next to particular cells. When I look at the code which moves graphs (using record macro and look...
  17. Oh you two are stars. That fixed it! Alan

    Oh you two are stars. That fixed it!

    Alan
  18. How can I stop my macro from asking to copy a name that already exists?

    I am copying tabs from two spreadsheets to one new one (two tabs - old data and new data).

    But each tab in the original spreadsheets have named ranges - the same names. So, the second copy always...
  19. I only have 6 points for each of the forecasts....

    I only have 6 points for each of the forecasts. Most of the data looks OK, but some is just silly (but only because I know better). For example:
    196 196 39 39 39 39

    This gives a negative number...
  20. Cheers - that's the conclusion I had come to as...

    Cheers - that's the conclusion I had come to as well.

    I'm still playing :)
  21. I think the "Forecast" formula is the best I am...

    I think the "Forecast" formula is the best I am going to get. It still gives weird results occasionally but I can't find anything better.

    Alan
  22. Predicting what the next numbers will be in a sequence?

    I have a list of numbers in cells in a row. Is the an Excel function which can predict what the next number is likely to be - so some sort of trend analysis?

    Alan
  23. Replies
    3
    Views
    233

    I love this one: "Do not open and save...

    I love this one:

    "Do not open and save directly from a floppy disk"

    Anyone still use a floppy disk?

    Alan
  24. Zeddy, I will try that - but probably not for a...

    Zeddy, I will try that - but probably not for a week or more as I'm just off on my hols.

    cheers

    Alan
  25. CSV's don't import properly if a macro has been run

    Anyone seen this?

    Excel 2010. I have some extensive macros. I open a .xlsm file and run a macro. Then,. I double click on a .csv file to import it into a new instance of Excel. The data all...
Results 1 to 25 of 213
Page 1 of 9 1 2 3 4