Search:

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

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Replies
    6
    Views
    335

    Re: Checkbox to change it's own label?

    Ah, the wisest of the wise have helped.

    I appreciate your help and wisdom. I particularly like the Format option too.

    Thanks very much.

    (bows deeply)
  2. Replies
    6
    Views
    335

    Checkbox to change it's own label?

    Greetings wise ones

    I would love to have a checkbox which, when ticked, changes it's text label to the date.
    eg [] Checkbox1 would become [√] 27-4-14

    My macro skills are less than basic so...
  3. How to write a Macro to find/replace based on a variety of requirements?

    Can anyone please give me an example of a Macro to:

    1) Do a find and replace on a worksheet AND
    2) Do the find using the contents of one cell AND
    3) Do the replace using the contents of another...
  4. Re: MRAND and RANDBETWEEN...I need a compromise between the 2!

    Sheesh!
    I can't believe I didn't see it before.

    MRAND(10,0,100)+100
    gives 10 random numbers between 100 and 200

    :laugh:
  5. MRAND and RANDBETWEEN...I need a compromise between the 2!

    Greetings all.

    If I use RANDBETWEEN I can get some random numbers between 100 and 200, with the possibility of repeated numbers.
    If I use MRAND I can get some random numbers between 0 and another...
  6. Replies
    2
    Views
    213

    Re: Help with adapting a macro

    Hey Datsmart

    Thanks very much for your reply.
    Just what I was trying to find out how to do.

    Cheers
    tigger
  7. Replies
    2
    Views
    213

    Help with adapting a macro

    Greetings!

    I have created a macro that copies a tick in cell O2 into cell D2.

    How do I adjust the macro so that it copies the tick into whatever cell I select?

    My recorded macro looks like...
  8. Re: Hide Unhide columns with macro but with changing columns

    jasonb75,

    Once again....awesome! Above and beyond what I expected.

    Thanks very much.
    I am taking some time to peruse your code and nut out how it works so
    one day maybe I can help someone...
  9. Re: Hide Unhide columns with macro but with changing columns

    jasonb75,

    thank you soooo much. It works a treat. You have helped me to learn a bit more about vb too!

    I guess the slightly "staccato" disappearing/reappearing of columns is due to the loop?
    ...
  10. Hide Unhide columns with macro but with changing columns

    Greetings.

    I have a sheet with 7 buttons, each button attached to a macro that wil show/hide the relevant columns for the button.

    The sheet has Row 1 with Headings but not in consecutive cells....
  11. Replies
    4
    Views
    708

    Re: Count until a blank cell is reached?

    Now THAT is a super bit of syntax. I thought there may have been a whole row solution but wasn't sure. Thanks very much pgc01.

    tigger
  12. Replies
    4
    Views
    708

    Re: Count until a blank cell is reached?

    Of course!
    Now I just need to do the maths for a years worth of school days! :)

    Thanks!

    tigger6333
  13. Replies
    4
    Views
    708

    Count until a blank cell is reached?

    I have a worksheet that contains dates across row 1 starting in Column B. Each day a new column is added. I want to count the number of cells containing dates.

    If I use COUNTA(B1:F1) on one day...
  14. Replies
    15
    Views
    12,246

    Re: Index page links in XL2007

    I would like to publicly thank Easy-XL Support for the wonderful assistance they
    have provided. Patient, helpful and informative. Truly professional.

    Thanks from a very grateful Tigger.

    ...
  15. Replies
    15
    Views
    12,246

    Re: Index page links in XL2007

    OK I tried this on a couple of workbooks with no problem at all.

    I'll have to do this tomorrow :)


    Have done. Thanks!

    Woohoohoohooooo!
    The Tig
  16. Replies
    15
    Views
    12,246

    Re: Index page links in XL2007

    Good idea....

    Well, it works fine. But it is running on a non Easy-XL version of Excel 2007.

    Another symptom I have noticed on my main (original) machine.

    If I create the index sheet, then...
  17. Replies
    15
    Views
    12,246

    Re: Index page links in XL2007

    The workbook was made by me locally, so no emailling or copying.

    The hyperlink base property is as you say it should be....blank.

    I really appreciate your persitent effort to help me. Thanks.
    ...
  18. Replies
    15
    Views
    12,246

    Re: Index page links in XL2007

    Further investigation shows that after saving, closing and reloading,
    the Index page is missing the "Comments" heading in Column A.

    When Easy_XL created the Index page, 7 cells below the list of...
  19. Replies
    15
    Views
    12,246

    Re: Index page links in XL2007

    Further investigation shows that using the HYPERLINK command on the other sheets
    works fine, even after the workbook is saved then reloaded.

    Curiouser and curiouser!

    Woohoohoohooooo!
    The Tig
  20. Replies
    15
    Views
    12,246

    Re: Index page links in XL2007

    What happens in 2007 and now in 2010 is:

    I have a workbook with 16 sheets.
    I use Easy-XL to create an Index sheet.
    After it's created the Index sheet has 16 hyperlinks which all work correctly....
  21. Replies
    15
    Views
    12,246

    Re: Index page links in XL2007

    Aaaaarrgghh!

    Now Excel 2010 is displaying the same symptoms.

    I have to delete the Index sheet and remake it with easy-XL in order for the links to
    work.

    This is starting to sound like an...
  22. Replies
    15
    Views
    12,246

    Re: Index page links in XL2007

    Hi and thanks for the quick reply.

    The workbook is a local file on my machine, not a network or sharepoint file.

    The workbook has no hidden worksheet.

    The index page created works ok in...
  23. Replies
    15
    Views
    12,246

    Index page links in XL2007

    Greetings

    I have a workbook in which I have created an Index page using Easy-XL.

    However, when I open the workbook in Excel 2007 the Index links do not work.
    When I open in XL2010 beta they...
  24. Re: Is there a more elegant way to cross-average?

    For your example of

    952 740 219
    485
    210
    357

    I assumed 952 was in B1, 740 in C1, 219 in D1
    485 in A2, 210 in A3, 357 in A4
  25. Thread: Sixth Day

    by tigger6333
    Replies
    11
    Views
    669

    Re: Sixth Day

    OK Using your table above I was able to get it
    sort of working, but with very convoluted formula.

    I think your idea of array formula is good but I dont know enough yet to
    help with that.
    ...
Results 1 to 25 of 43
Page 1 of 2 1 2