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

    Writing in bytecode

    Is it possible to write script exactly in bytecode (I mean using characters with ASCII code less then 32). I know that perlcc -B can be used, but it generates bytecode with architecture information and such a code can't be executed on other computers with different compiled perl (for example...
  2. tytus2005

    Shortest code

    I don't know... I haven't seen the code... BTW: We do not count characters with ASCII code less or equal to 32... I don't know if it makes much difference... Do you think it's impossible to do it in just 10 chars (with ASCII code>32)?
  3. tytus2005

    Shortest code

    Thanks a lot... But now I have a real challange... We are given a set of numbers: x y_1 y_2 y_3 ... y_x y_x+1 y_x+2 ... y_n We have to write program that will read only x first values from the input and sum up only those which are greater then zero. For example: 5 4 3 -3 -1 4 -8 12 11 10 5 6...
  4. tytus2005

    Shortest code

    And I'm also not allowed to use "-ln"...
  5. tytus2005

    Shortest code

    I'm not allowed to use "-l"...
  6. tytus2005

    Shortest code

    Hi, I'm learning Perl and for now I'm on regexp. With my friend, we make some challnages for shortest code. We have such a task: We are given some words (of length at most 20). These words are made only from capital letters (A..Z). We want to count and print out 2**(number of letters A,B,C,D)...
  7. tytus2005

    How can I require user to fill cell1 also if he/she fille cell2?

    Of course you should also add to loop condition something like: Do x = InputBox( "Enter date", "Date" ) Loop While (x = False Or x = Empty Or Not IsDate(x))
  8. tytus2005

    How can I require user to fill cell1 also if he/she fille cell2?

    Maybe you should try something like this: In your Worksheet_Change subroutine replace MsgBox with InputBox like this Dim x as Variant ... Do x = InputBox("Enter date", "Date") Loop While (x = False Or x = Empty) If user submits without entering anything x will be equal empty, if user...
  9. tytus2005

    UserForm.Show Error

    I have three UserForms in my Excel VBA Application. First Form is to select files to compare, second is some kind of progress bar, and third is to show when duplicated cells are found - it should let users choose which value is correct. When first duplicated cell is found everything is ok - user...
  10. tytus2005

    String manipulations

    I wonder if there is any way to manipulate strings in VBA just like it can be done in C/C++. I mean - is there any way to do something like accessing single letter with []? For example is there any way to check for example third letter in a word in C/C++ way (word[2])?
  11. tytus2005

    Excel catching paste event

    I decided to use a hidden column solution, so now there is no need to check what users are coping/pasting. Anyway it is nice to know that there is such a function in VBA (I don't have help files installed so actually it is really hard for me to check anything). Maybe I am wrong, but should any...
  12. tytus2005

    Excel catching paste event

    I have such problem: In a cell there is a formula with constant $J$<row>, where row changes for each 20 rows. When someone is coping/pating a row I want to check is thers this formula and if so I want to find proper row number and replace it in formula. I'm trying to use change property and I...
  13. tytus2005

    Excel catching paste event

    Hello! Is there any way to catch paste event in excel vba. I mean - I need to catch it, check if there is any dollar sign and if so change the address, otherwise paste it without changes. Any idea how to do it? Best regards, Tytus
  14. tytus2005

    Printout

    You're right - but from the unknown reasons on 3 (from 4) of my worksheets it didn't work. But as they were very similar to each other I've just copied the correct one and now everything is ok. But still - I don't know why it wasn't working before. Best regards, Tytus
  15. tytus2005

    Printout

    I wrote a macro to hide an empty rows - and it works ok, but when I want to print sheet with hidden rows, excel show (on printout preview) empty space - so even if I want to print only one row (from 40 I have) I get one row on first page, then empty space and last row (summary) on second page -...
  16. tytus2005

    Headers fields recalculation

    Is there any way to recalculate fields inserted in header after the detail section has been calculated - I mean - if I would like to insert in header information about the number of records in details sections I need a way to calculate it at the end - when I'm just putting it in the report it...

Part and Inventory Search

Back
Top