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 derfloh 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. Evening

    Setting the row height in Excel with VB

    Thanks Loomach for help, it looks it's working
  2. Evening

    Setting the row height in Excel with VB

    I have a spreadsheet with some 1000 rows and 20 columns. The fields are formated with a wraped text feature. Some of the fields contain longer text, so even they are formatted with wrapped txt, can't be readable when I print the sheet out, because the row height is not enough . I don't want to...
  3. Evening

    VBA- Excel COUNTIF

    I am running the VBA code from sheet1. Selecting another sheet FMA, and finding the last row . I want to define variable CN, where it shows the number cases in fields in Column Y, from row 11 to LastRow, where the value is greater then 0. How can I define the variable CN?. Select Sheet1 . ...
  4. Evening

    Sorting in Excell - VBA code

    Thanks Skip, it's working. I love this web site, I can always find someone to help me
  5. Evening

    Sorting in Excell - VBA code

    I'm sorry i forgot to put the line of error . When it get's to sorting, so line : Selection.Sort Key1:=Range("G11"), Order1:=xlAscending, Key2:=Range("B11" _ ), Order2:=xlAscending, Key3:=Range("C11"), Order3:=xlAscending, Header _ :=xlGuess, OrderCustom:=1, MatchCase:=False...
  6. Evening

    Sorting in Excell - VBA code

    Can someone help me to solve my little problem. I have 2 sheets, RPN & FMA. I'm making a VBA codes in sheet RPN. I am in RPN sheet and want to go to sheet FMA. I want to sort it according some criteria, then copy first 10 rows, come back to sheet RPN again, and paste the copied fields. The...
  7. Evening

    Visual basic - VLOOKUP

    Thanks Skip, it's working
  8. Evening

    Visual basic - VLOOKUP

    Can someone help me how to do this. I started something but cant figure out myself 100%. In have in SHT-1 columns A & B, C D, . Column A- B-Ident Number C-Description … D- .. In SHT-2 I have : A - .. B -...
  9. Evening

    Copying from other worksheets

    I have 13 Excell worksheets, 1,2,3.. 13, one for each month & 1 more for summary. I am entering some data for each month in separate worksheet in columns A-F, starting for row 4, to below (I don't know how many rows will be in the end of the month.) I want in sheet # 13 to be the summary of data...
  10. Evening

    VBA programming in Excell

    Thanks Pinkgecko, it's working. I'm not a profesional programmer, i just used a macro creating the program, where the macro created the program as i described. Later when i put the macro codes in my full VBA program, just didnt work. Now I understand why.... Thanks again.
  11. Evening

    VBA programming in Excell

    Here is the part of the code: I am in worksheet BAS_E. from this worksheet I want to go to worksheet GEA_E Sheets("GEA_E").Select Range("D10:D13").Select Application.CutCopyMode = False...
  12. Evening

    VBA programming in Excell

    I have a workbook with 5 worksheets. I made some VBA prgram initiating in worksheet-1. Is it possible with this same VBA program to choose other worksheets,(worksheet-2) copy some cells from worksheet 2 and also paste them in the same worksheet-2. This will be repeated with worksheet 3,4 5, and...
  13. Evening

    VBA -isn't working in Excell 2007, working in Excell 2003

    Skip Thank you for reply.. Basically it couldn't calculate the value...It was an error in field ... I found later that the macro wasn't set properly in Excell 2007... I am new in Excell 2007, very difficult to find appropricate command, but 2 hours later finally i succeded to enable the...
  14. Evening

    VBA -isn't working in Excell 2007, working in Excell 2003

    I forgot to tell that if i open a create a new workbook in Excell 2007 and place the calcuations, it's working. If I open the workbook in Excell 2007 which was created in Excell 2003, isn't working. What's the difference?
  15. Evening

    VBA -isn't working in Excell 2007, working in Excell 2003

    I used a special VBA defined calculations in Excell under 2003 version, and it was working without problem. When I run this under 2007, isn't working. Why? The calculations looks like this: Function AngleSol(B As Double) As Double ' Find the value F such that F - Tan(F) = B Dim Epsilon As...
  16. Evening

    Word - mistery

    Thanks, i found some information on the google...
  17. Evening

    Word - mistery

    If you open Word new document, and enter the following: = rand (200,99) and press enter. See what happens. Can you eplain what's going on?
  18. Evening

    VB programming - Managing sheet-2 from sheet-1

    Skip Your suggestion didn't work out. Giving instruction in VB worksheet MENU to change the Protection of some fields in workesheet BASIC DATA. I tried to use some password protection in order to allow some poeple to chnage some data in the worksheet BASIC DATA. This is what i tried: Private...
  19. Evening

    VB programming - Managing sheet-2 from sheet-1

    I have 2 worksheets in the workbook, 1.MENU, 2.BASIC DATA I am in MENU worksheet.(BASIC DATA sheet is hiden) Double click on OPTION-1 in MENU worksheet initializing VB Sheets("BASIC DATA").Visible = True ActiveSheet.Unprotect Range("D6:G11").Select Selection.Locked = False...
  20. Evening

    VB for Excell

    Thanks Skip, it's working. If i move the cursor to field B1 for instance, the program iniciates the happenings what i described. In my menu I described 8 items, from B1-B8. Sometimes it is unexpected that moving the cursor to the next field, immediatelly iniciates the program. Is it possible to...

Part and Inventory Search

Back
Top