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 gkittelson 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: *

  • Users: Ranf
  • Order by date
  1. Ranf

    function to know if #DIV/0 error in the cell

    Genius is in Simplicity 10x so much, Made my *life* much more fluent :)
  2. Ranf

    function to know if #DIV/0 error in the cell

    which function in VBA can tell me that a cell has a #DIV/0 error so I could change its value to ""? (Say something like "if (cells(1,1).XXX) then cells.value="") I guess it's elementary but I'm on this one for the whole afternoon ... :(
  3. Ranf

    "subscript out of range" for the sub headline

    Hi everyone! I get a "Subscript out of range - Runtime error 9" marked on the "headline" of the sub ("Sub Sortand..."). It happens only when I change the file names inside the function. For some it works and for other doesn't. I've verified that the files exist...
  4. Ranf

    Hi Everyone, I would like to ask

    Hi Everyone, I would like to ask something which I guess is basic for many of you, but I'll ask anyway, just because I don't know the answer myself.. Here it is: Basicly I would like to know which command can I use in order to choose a cell with i,j (- integers) when i stands for the column...
  5. Ranf

    Running a Program

    Hi, I have a code which starts with several "include XXX.h" statments. I can "build" and "make" its project, and compile the file. When I'm trying to run the program though, I get an error messege saying "Unresloved External" for every function which...
  6. Ranf

    Using the Index of a For Loop to Name files

    Hi, I have a working macro that open one file at a time (looks like "Alpha-111"). I would like to add 3 "For" Loops with three Indexes to name the numbers-part of that file name, since I have plethora of files like this one. Do you find it Too Simple? well, I'll try to come...

Part and Inventory Search

Back
Top