Search results for query: *

Thanks Ilses, your helped to solve my problem. Also XLBO, thank you for your info, I did not know that, in the future i will try to use right VBA forum for my VBO questions.

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

Can anybody explain me how can you record with macro to hide every rows from (1-64000) whatever has less then 1 for value in column M, after sorting? Also to set the page for printing to get printed the page with all rows and columns where the value in column M=1? Thanks

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

Thanks guys for advise, Dale you gave a good suggestion as always in the past, I will try out your suggestion today or tomorrow, will give some feedback how it works. Les

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?

Zathras I understood what's your intention with your last suggestion, but probably I did not specify correctly in the program. I had your previous Worksheet_Change and I tried to combine now with your last suggestion. I understand I have to the specify Option Explicit on module level: (May I...

Thanks Zathras I would never imagine I can fix the problem on this way, mainly becasue don't know what are the real possibilities in Excell. I am the old Fox-Dos database programmer, I can use a lot of ideas and techniques to solve the problems, but don't know all the tools in Excell. So, I've...

Thanks Zathras I did not experience this trouble, becasue I always changing those nubres indipendently, no need to paste it, but I will add this change in the program. If you wil read this text, I will ask you something else (Or I will place another thread): Same scenario as above need to hide...

Zathras Bingo. You're the master of the Excell! It works so beautifull, did not belive it. Based on the sample, I've even developed the program for more different ranges, so I can use it in the future for similar projects. Thank you again for your help. Also Dave and Gavona I appreciate your...

Thanks everybody for suggestions,especially to Zathras, I will try to set it up my file this evening and will inform you how it worked. It's just excited to learn here from experts in Excell.

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

Geoff It Looks I am lost, spent whole day working on this program.As you told I made just a sub worksheet_change. but just does not work. Made 100 different scenarios, got 100 errors, or no errors but nothing happened with hiding unhiding. Maybe I try to put a new thread, with a description...

Geoff I tried to change even names of fields to avoid the troubles, this is the last I had in the program: ----------- Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) Select Case Target.Address Case Range(&quot;num1&quot;).Address Call No1Change...

Geoff I 've copied you suggestion to my file, and wrote one of the subs (NumChange) you suggested, still does not work, got a error: Run Time Error &quot;1004&quot; Method 'Range' of Object_Worksheet' Failed. My first sub looks like the following: (I must made some error) Sub NumChange(ByVal...