Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. kragster

    Problem with data validation

    Yeah well slow as you are, you deserve credit for trying to help me :-)
  2. kragster

    Problem with data validation

    Ok I figured it out. Had a user that put a filter on the table and didn't remove it before he saved. Thats why the table seemed to have hidden rows, but actually just was filtered ;) You learn new things every day.
  3. kragster

    Problem with data validation

    Hi Geoff. Nice to know! I have another question though: in the same spreadsheet, suddenly a lot of rows are hidden and I can't unhide them. Whats going on when a program suddenly does things on it own?! Any suggestions as to how I can unhide them are much appreciated?
  4. kragster

    Problem with data validation

    Thanks to both of you. Geoff, I had frozen panes in the spreadsheet but I started by repairing the file and that worked! Thanks a lot.
  5. kragster

    Problem with data validation

    Hi, About a week ago, something weird happend to one of the spreadsheets that I am continously working on. All the drop down boxes disappeared and now I cant seem to get them back. What I do when I want to make a drop down menu is this: I mark the cell where I want it to make a drop down menu...
  6. kragster

    Simple macro problem

    Thanks skip. You allways got the solution!
  7. kragster

    Simple macro problem

    Ok I solved it the following way: Sub delColumn() Range("A12").Select Do Until ActiveCell.Value = "" If ActiveCell.Value = "C1" Then ActiveCell.Columns("A:A").EntireColumn.Select Selection.Delete Shift:=xlToLeft ActiveCell.Offset(11,-1).select ElseIf ActiveCell.Value =...
  8. kragster

    Simple macro problem

    Hi, I am trying to make a simple macro, but I'm stuck and need some advice. The macro should go though the cells of a row and when the cell contains specific data it should delete the entire column. This is my code so far (probably not the right way of doing it): Sub delColumn()...
  9. kragster

    Help with loop..

    Thanks Mike. It makes sense now!
  10. kragster

    Help with loop..

    Can anyone explain to me what this does in the loop? Cells(datarow, 1) = VBA.Right((Cells(datarow, 1)), Len(Cells(datarow, 1)) - 5) Any help is much appreciated.
  11. kragster

    Help with loop..

    I have a huge nested loop in which I am trying to find out where it gets the legend data from. Instead of the current legend data I would like it to use Range("B" & datarow), thus B3 the first loop and B11 the second and so forth. here is the loop: datarow = 3 Do Until Range("A" &...
  12. kragster

    Help with loop..

    PHV: I'm kinda new to programming so you would have to explain to me how that is done ;-)
  13. kragster

    Help with loop..

    Thanks Mike. I'm trying to edit another persons VBA project, but I have a hard time figuring out where he loads his data from into some specific cells. This means that this loop only inserts empty rows, doesn't populate them with data. *sighs* I'm trying to edit another persons VBA program, but...
  14. kragster

    Help with loop..

    Hi, I have a bit of trouble understanding a part of this loop, so if anyone would be so kind to translate it, it would be much appreciated. Dim AssayRowIns AssayRowIns = 4 Do Until Range("A" & AssayRowIns) = "" Rows("" & AssayRowIns & ":" & AssayRowIns + 6 & "").Insert...
  15. kragster

    macro that sorts a range from the last 5 characters

    Thank you both. Two excellent ways of doing this ;)
  16. kragster

    macro that sorts a range from the last 5 characters

    Hi, I have a problem sorting a table from a column containing order numbers. The order numbers have the following format: ABC00001 -> three letters succeded by 5 numbers. What I wanna do is sort the orders by the last 5 numbers, disregarding the three letters. Can anyone help me on the way here?
  17. kragster

    practice for protecting formulas

    Hi, I have a rather large spreadsheat containing a table of data. Some of the cells contain data from user input, and some contain VLOOKUP formulas. What is the best practice for protecting these formulas? I tried making the cells with formulas writeprotected and then protecting the whole...
  18. kragster

    Displying xls file in a HTML document?

    Well I guess not then ;) In my oppinion it looks awful.
  19. kragster

    Displying xls file in a HTML document?

    Hi Sleidia, It is for an intranet page and all our employees have excel. I just want it to look prettier ;)
  20. kragster

    Displying xls file in a HTML document?

    Well that looks good, but I was hoping it could be done with HTML code. Thanks though for the link.

Part and Inventory Search

Back
Top