Search results for query: *

Thanks Loomach for help, it looks it's working

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

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

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

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

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

Thanks Skip, it's working

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

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

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.

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

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

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

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?

...such that F - Tan(F) = B Dim Epsilon As Double Dim Counter As Double Dim F As Double F = 0.1 Epsilon = Tan(F) - F - B While (Abs(Epsilon) > 0.00000000001) And Counter < 100000 F = F * (1 - Epsilon) Epsilon = Tan(F) - F - B Counter = Counter + 1 Wend AngleSol = F End...

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

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?

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

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

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