Search results for query: *

In VBA programming one of the rows I do filtering instruction 1) With Columns("M:M") .AutoFilter Field:=1, Criteria1:="<>0", Operator:=xlAnd End With One of the possibility later is to undo the filtering, so I do the instruction 2. ActiveSheet.ShowAllData If I do the...

2 months ago my Windows XP stuck, and i couldn't do anything but plug out from power. From that time, every time during the booting is the following. 1. Message HARDWARE MONITOR FOUND AN ERROR. ENTER POWER SET-UP MENU FOR DETAILS. After i enter it i can read the following: - MB Temperature...

I have 300 rows data, and sorting it descending according column A. The value in column A can be 1,or 0. After sorting I want to hide all rows where the value in A is 0. Because I've sorted it as descending, I want to hide rows from first row where the column A is 0, to 65536. How can I find...

I have a sheet where using columns from A to M with some data. I want to sort data based on column M descending, + column K descending from row 10-300. Column M have a values 1 or 0. After sorting from 300 rows only few will have value 1. I want to hide all rows which have value 0. I want to...

I have a data of few thousands rows where the number can be in D,E column, or in F,G (but not in both DE, and FG columns in same row) A- Group the part belongs (total 4 groups, group-1, group-2, group-3, group-4) B- Part ident # C-Date and time when the measurements happened. D-Measured...

I have a different values for some measured dimensions entered in column A. (assume Total 5200 records) I want to make some counting , based on range of the mesurements: Like A) L<1 = 1,200 records B) 1<L<5 = 2,500 records C) 5<L<10 = 1,300 records D) L>10 = 200 records TOTAL...

I have a spreadsheet with a lot of fields on it, and pretty difficult to print it out on one page. I can do it on the legal size of paper, but the readability is the question, very small letters, and just difficult to read it. On the Screen I can scroll Left-Right, Up-Down, I want to leave the...

Is there any utility routine to generate involute curve in Autocad, to draw gears?

I already asked this question, got few answers, but did not work exactly. What I want is to hide-unhide some rows, depending from values in 3 different fields. I want to change independantly these values. For Example: - I have 3 fields, num1, num2, num 3...

The following program will hide and unhide some rows depending from value in field &quot;num&quot; (Nice program from Dave W.) Private Sub Worksheet_Change(ByVal num As Range) '1 = unhide rng_1 and hide rng_2 '2 = hide rng_1 and unhide rng_2...

I want to copy some cells with a formulas from file-1 to another file file-2, copying the formulas over. In the end I just got the values calculated by a formula in a new file -2 but not the formula itself. In the first file-1 in a formulas I am using field names given by me. I understand that...

Can somebody help me in this problem. I want to hide and unhide some rows in Excell depending from the values entered in cell A1. If the value in A1=1, unhide rows from 90-130, and hide rows from 131-170 If the value in A1=2, hide rows from 90-130 and unhide rows from 131-170 In any...

How can I give an instruction to hide and unhide some fields on screen? I want the following: I want to write in field A1= 1, 2 or nothing . If in field A1=1, unhide B2: E10 A1=2 hide B2:E10 and unhide F2:K10 Otherwise hide all B2:K10. May I use an unused field (like A2) and write...

I want to find the value A1 in worksheet #1. This value will be found in worksheet # 2, which has column A,B,C (some 500 records, already preentered values) WORKSHEET # 2 A B C 1. 2.5 0.5 3 2. 2.5 0.7 4 3. 2.5 1.2 5 4. 3.0 0.8 4...

I have 4 column table, (A,B,C,D) where I have a D column values already determined based on A,B,C values. Now, later in other application I want to know the D value based on some given values for A,B,C ( D=Function(A,B,C) ) For example I give a query for D=F(A=2.5, B<=1.5, C>=1.7) If value in...

How can I sort in Excell based on 2 or 3 features? Example I want to sort base on column A,B,C, first on order o column A, then column B, then column C. The following example: A B C ---------- 10 A 1 10 A 2 10 A 3 10 B 1 10 B 2 20 A 1 20 A 2 20 A 3 20 B 1 30 A...

How can I disconnect the link between 2 workbooks in Excell? I guess I was copying some information from one workbook to other, and now when I always open the second file, it is asking me do I want to update this workbook from related one? I don't have any relation between 2 workbooks, so I want...

Can somebody help me. There is a math formula: Tan(F)-F=B where &quot;B&quot; is a known value, I need to find the &quot;F&quot; unknown Angle in radians I can calculate F manually changing the value for &quot;F&quot; . Is there any way in Excell to...

My friend is using a Windows 98, and only she is using the computer. Today she suddenly had a problem during boot up. At very very beginning, when you just see the basic information about processor, at the line when the system is checking the NVRAM, suddenly on the black screen...

My friend is using a Windows 98, and only she is using the computer. Today she suddenly had a problem during boot up. At very very beginning, when you just see the basic information about processor, at the line when the system is checking the NVRAM, suddenly on the black screen appears text...