Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.10 seconds.

  1. Thank You Andrew But I do not see Insert >...

    Thank You Andrew

    But I do not see Insert > Comment on my ribbon. Is it hidden or do I need to install anything extra?

    Wassim
  2. Hi Craig Sorry RetiredGeek but Craig wants all...

    Hi Craig

    Sorry RetiredGeek but Craig wants all non Saturday or Sunday worksheets to be "default color", so all I'll change is last line in the case statement from sht.Tab.Color = vbWhite to...
  3. Need something similar to Excel's cell comments

    Hello All,

    I am sorry to ask this question in this lounge, but truly it does have to do with MS-Word 2010. In MS-Excel you can have a cell comment. It will display in a "bubble" once you select...
  4. Replies
    1
    Views
    140

    How to make text tilt? MS-Word 2010

    Hello All,

    I am trying to start a newsletter and I am wondering if I can make the font/text tilt to the right?

    So what I mean by tilt is that some times I see this font where the 'A' letter has...
  5. Replies
    17
    Views
    1,924

    [SOLVED] Thank You kweaver I checked it, it is easy to...

    Thank You kweaver

    I checked it, it is easy to understand and I will use this example.

    Great work, as usual.

    Cheers

    Wassim
  6. Replies
    20
    Views
    991

    Hi BudE How about saving the worksheet before...

    Hi BudE

    How about saving the worksheet before printing. Remove the shading and then print and close without saving.

    This locks in all the changes plus the shading. You can use something like:
    ...
  7. Replies
    17
    Views
    1,924

    [SOLVED] Hi kweaver Then all Items will have their...

    Hi kweaver

    Then all Items will have their numbers -2 so Item #3 becomes Item #1, Item #4 becomes Item #2 and Item #200 becomes Item #198.

    The problem I am having is to write the formula that...
  8. Replies
    17
    Views
    1,924

    [SOLVED] Thanks Fred You gave me some starting points,...

    Thanks Fred

    You gave me some starting points, please see my additional reply to Paul.

    Thanks again

    Wassim
  9. Replies
    17
    Views
    1,924

    [SOLVED] Thanks Paul Here is a visual representation: ...

    Thanks Paul

    Here is a visual representation:

    Item Number ... Sold/Unsold ... New Item Number
    1...................U...................1
    2...................U...................2...
  10. Hi Judy You may want to also check what kind...

    Hi Judy

    You may want to also check what kind of "Print Area" is assigned. In Excel 2013 look at the Page Layout menu tab and there in the Page Setup Group you will find a Print Area dropdown that...
  11. Replies
    17
    Views
    1,924

    [SOLVED] Need a running-total formula

    Hello All,

    I am working on a template and I need your help. I am not sure if you could call it a "running total" but it does have some of the elements in common.

    OK let me explain.

    I have a...
  12. Thanks Andrew Yes I agree that the setup is...

    Thanks Andrew

    Yes I agree that the setup is not the ideal, but this is what I inherited.

    I have one of two options:

    1) Make each row in each column of different width, and I don't even know...
  13. justifying text in a merged cell in a table

    Hi Loungers

    I am writing a newsletter and I want to have a table of content.

    This table of content is going to be on the first page of the newsletter, where we have a table of 2 columns by 2...
  14. Replies
    0
    Views
    442

    Web Query to get all result pages

    Hi Loungers

    Is there a way to run a web query that can bring all resulting pages?

    For example you go to a web site and run a query for events happening between two dates. The results come into...
  15. Replies
    4
    Views
    684

    I need some design help

    Hi All

    Can anyone tell me how can I get the following done:

    I am building what I call a Dispatcher's Application. So here goes:

    I have a User form with a bunch of controls. The dispatcher...
  16. Replies
    7
    Views
    2,066

    Hi SteveNot really. I have less than 400. Unless...

    Hi SteveNot really. I have less than 400. Unless 400 is considered lots.What I see is a value being entered into a validated cell then the validation happens and the error message comes up and I...
  17. Replies
    7
    Views
    2,066

    Thank you Maud and SteveBut using data validation...

    Thank you Maud and SteveBut using data validation seems to produce a delay in processing where the cell value has not yet updated and the validation kicks in and produced an error.I will try and...
  18. Replies
    7
    Views
    2,066

    Limiting user input

    Hello AllI need to limit the User input to be only the next number higher than what is available.So in column BO I have a CountA formula to add up how many cells it the row are not empty. I can add...
  19. Replies
    8
    Views
    2,236

    Thanks Kweaver This did the trick. I was...

    Thanks Kweaver

    This did the trick. I was trying to use a range of exclusions but an If/And will work just fine.

    Thanks again

    Wassim
  20. Replies
    8
    Views
    2,236

    I am sorry Kweaver I hope that I have made my...

    I am sorry Kweaver

    I hope that I have made my question clearer by using this workbook as an example.

    Please let me know if it is still not clear.

    Sorry I had attached the wrong file but now...
  21. Replies
    8
    Views
    2,236

    Thanks RetiredGeekIn a nut shell which is what I...

    Thanks RetiredGeekIn a nut shell which is what I was supposed to do in the first place:I want to find duplicates in a column but not all duplicates.I want to find if I have 13 duplicated but I don't...
  22. Replies
    8
    Views
    2,236

    Check for certain duplicates but not all

    HelloI know that the CountIf has a range and criteria parameters but it does not seem to let me use them.For example I want to find duplicates in the range of 2 to 50 but exclude any letters.I have a...
  23. Replies
    2
    Views
    1,063

    Hi zeddyOK I am sorry this post does not contain...

    Hi zeddyOK I am sorry this post does not contain an answer for you but:1) Have you tried stepping into the macro code line by line and see whet line fails or what is happening that you disgruntled as...
  24. Replies
    5
    Views
    1,571

    Hi AllPardon me but why was a solution made of...

    Hi AllPardon me but why was a solution made of linking the worksheet cells in all these workbooks passed?I thought of this as I was reading the post.Any limitations on linking?Wassim
  25. Replies
    2
    Views
    670

    Some design ideas please

    Hello LoungersI have a project to complete and I would love to bounce some ideas and get some feedback.The application is a schedule app. and I will have the days of the week in row 1 and the names...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4