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!

  • Congratulations strongm 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. ItIsHardToProgram

    Run Time Error 1004 App Defined or User Defined Error

    Ok, you should still take PHV's advice as it improves your macro, and you should definatly take SkipVought's advice, at least if you want to use SheetNM, put it as Cstr(SheetNM), but there is still a risk that SheetNM does not contain a valid Worksheet for your current workbook. "Knowing that...
  2. ItIsHardToProgram

    Run Time Error 1004 App Defined or User Defined Error

    Well, there are quite a few dark corners of vba for me, I seriously thought x1down was not correct, and it had to be xldown ("L"), SkipVought am I missing something? "Knowing that you know is the greatest sign of stupidity, knowing that you are ignorant is the best proof of intelligence.
  3. ItIsHardToProgram

    Run Time Error 1004 App Defined or User Defined Error

    Good that it works, although I do not quite grasp what you are saying, wasn't x1 down what was written in the first place? "Knowing that you know is the greatest sign of stupidity, knowing that you are ignorant is the best proof of intelligence.
  4. ItIsHardToProgram

    Run Time Error 1004 App Defined or User Defined Error

    This works for me: Sub CreateOutput() Dim SheetName As String SheetName = "test" Dim RowCount As Integer RowCount = ActiveSheet.Range("I1").Value Dim RowCountAbs As Integer Sheets(SheetName).Select ActiveSheet.Range("A6").Select ActiveSheet.Range(Selection, Selection.End(xlDown)).Select...
  5. ItIsHardToProgram

    Looking for criticism.

    Thanks! Yeah Andy, I again am 100% behind what you are saying, the reserved names variable werent entered by me, but I should definatly correct those, and for the sticking to 1 way of naming variables, you are right, when you finish something friday, sometimes theres a few slipthrough. Thanks a...
  6. ItIsHardToProgram

    How come AdvancedFilter is not working?

    There is a common recognition here that goes up by a little purple star! Considering how giving people are around here, a few clicks for a purple star, and donations of 1/1000th of what the cost of the expertize would've been is a small thing to do. "Knowing that you know is the greatest sign...
  7. ItIsHardToProgram

    From 32 to 64 bits ><

    Yes HughLerwill, this is actualy the article that I started working upon, but I don't know if it is because I am trying to resist change, but I don't quite grap how I should start to apply it. They talk about conditional, "if VB7" which is probably what I should start using, but I don't know...
  8. ItIsHardToProgram

    Looking for criticism.

    Besides the few "lazy" for's this code relies on alot of arrays, I am having trouble understanding how multi-dimensional arrays would help my cause, of course it would limit the quantity of arrays, but every single operation on the string would still need ot be done exactly how it is done...
  9. ItIsHardToProgram

    Looking for criticism.

    Alright skip, back to step one! The logic is fairly simple. We have a worksheet that currently has multiple lines, and each line is a grouping of multiple lines in another specific worksheet. The grouping is always done in arithmetic fasion: (i.e., sum(), +, -(), +(), -sum(), etc...) Any type...
  10. ItIsHardToProgram

    Looking for criticism.

    Here is the commented code (kindof? D:) Function SplitMultiDelimsEX(Text As String, DelimStrings As String, _ DelimStringsSep As String) As String() ''''''''''''''''''''''''''''''''''' ' SplitMultiDelimsEX ' This function is like VBA's Split function or the SplitMultiDelims ' function, also...
  11. ItIsHardToProgram

    Looking for criticism.

    You are 100% right! I got extremly lazy and wanted to comment the whole thing, but for the sake of the exercise I will comment this in english for the reader, I understand he can feel extremly dizzy from reading the whole code >< "Knowing that you know is the greatest sign of stupidity, knowing...
  12. ItIsHardToProgram

    From 32 to 64 bits &gt;&lt;

    Hey, I don't want to take a whole lot of your time, I am simply looking for a good article on how to design or tweak a code for it to work on 64bits and 32 bits machines. To put you guys into context I have designed about a year and a half ago a sort of database for timesheet / projects, in...
  13. ItIsHardToProgram

    Looking for criticism.

    Hey, I have recently designed a macro in order to split a cell arithmetic into mutltiple cells. This is a quite simple concept, but I found the time it took to design this, what I would think, "simply" macro, was quite arsh, I put around 5 hours on this, and I realize that my lack of experience...
  14. ItIsHardToProgram

    Hungry for knowledge!

    Thanks for all your hints, Ill keep that in mind and try to get a project started. You might hear from me :) Julien ~ "Knowing that you know is the greatest sign of stupidity, knowing that you are ignorant is the best proof of intelligence.
  15. ItIsHardToProgram

    Hungry for knowledge!

    ! ? ! So any way, bug fixing is a mearly part time job I was doing to help my dad, since I programmed his database. Im an accountant full time mind you! Either way, The real project I did was a whole environment using excel / access with VBA in order to accumulate hours per project and...
  16. ItIsHardToProgram

    Different Autoshape per Results

    Select Case Actual Case Is < BaseLine 'RED frown ShowShape "RedShape" Case Is >= Tgt 'GREEN smile ShowShape "BlueShape" Case Else 'YELLOW neutral...
  17. ItIsHardToProgram

    Return to prior worksheet after sub

    Or you can definatly just have xlbo help you. "Knowing that you know is the greatest sign of stupidity, knowing that you are ignorant is the best proof of intelligence.
  18. ItIsHardToProgram

    Return to prior worksheet after sub

    Hello Whitoja! I can see you are new to this forum and I would suggest that you read the FAQ on how to post a complete question! This would help the greatly experienced programmers in here narrow down your problems and send you on the best path for a solution. Its definatly worth it and its...
  19. ItIsHardToProgram

    Hungry for knowledge!

    Hey, I am currently working as a bug fixer, and the lack of questions sometimes bore me out. So I figured I would try to add to my VBA knowledge. The only place that I know off to learn about programming, and learn it well I might add, is to read on these forums. Could any one suggest some good...
  20. ItIsHardToProgram

    Vba Query - unexpected error

    Thanks for the tip! I will keep this in mind next time I have SQL in my VBA! "Knowing that you know is the greatest sign of stupidity, knowing that you are ignorant is the best proof of intelligence.

Part and Inventory Search

Back
Top