Recent content by Gamnis

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...

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...

I would like this functions as well :)

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...

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...

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

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

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...

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...