• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. G

    How to write intervals in VB

    Hi All I'm trying to write a VB code that vill help me marke all values between 7400 - 7500 I have tried something like this ------------------------------ Range("A4:A40").Select Rng = Selection.Rows.Count ActiveCell.Offset(0, 0).Select Application.ScreenUpdating = False For...
  2. G

    listing names

    No this is not exactly how I whant it. I have the list of names wich is from a spredsheet with alot of different data based on time. Ex: date;data;data;data;...;username1 date;data;data;data;...;username2 date;data;data;data;...;username3 and so on... I whant to list the usernames in the...
  3. G

    Need VBA code for the below..

    I would like this functions as well :)
  4. G

    Do not display IF ZERO

    Well the easiest way is to uncheck the "To display zero (0) values in cells" You can find it under the tools menu / advanced and quite far down you find "Show spreadsheet alternatives" or something like that. My version of XL 2007 is in swe so the English names may not be exact One other way...
  5. G

    listing names

    Hi all I need help with a formula. I have a bunch of names in a column like this A -- 1 John 2 Benny 3 John 4 Anna 5 Anna 6 Benny 7 Beatrice and so on... Many of the names occur multiple times, but I whant to return them only once. like this B -- 1 Users: John, Benny, Anna...
  6. G

    Get user Signatur

    Nice! Thanks alot Myles :) I just wrote the skrip like this: Activecell.Value = Environ("username") It worked out exactly like I whanted
  7. G

    To get correct time format with incorrect value??

    This worked out just fine :D Thx alot! And have a nice day Radu
  8. G

    Get user Signatur

    Hi Right now i'm trying to find a way to copy the name or signature from the user thats logged in to the computer I have seen this work but I have had some trubble finding an example of it. So I hope some on of you guys can help me? EX: The user fills out my form and then presses a button...
  9. G

    To get correct time format with incorrect value??

    Hi My name is Richard and I'm new to your webbsite. I'm working on an excell sheet that is going to collect information from different people with differrent knowledge in excel. Basically most of them does not know the right format for example time. To get the right time format you need to...
Back
Top