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!

Recent content by kragster

  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 ;)
See more

Part and Inventory Search

Back
Top