Search results for query: *

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

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

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

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

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

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?

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

I'd like to make a main menu in Excell like: MENU Row Column B C D 1 Option-1 2 Option-2 3 Oprion-3 4 ---- 5 ----- I'd like to iniciate some events with clicking on some field by mouse, or by pressing enter. So If I click on the...

I'd like to make a main menu in Excell like: MENU Row Column B C D 1 Option-1 2 Option-2 3 Oprion-3 4 ---- 5 ----- I'd like to iniciate some events with clicking on some field by mouse, or by pressing enter. So If I click on...

I'm looking a highly accurate way to draw the involute. Any suggestion? I'm using AutoCad 2004. In the past in AutoCad 12 I used a nice LISP program IMPORT-3D-POLY written by Tony Hotchkiss, 2003 program which has converted from Excell Spreadhseet the involute cordinates into polyline in...

I have a trouble with MSN messenger. I had a trouble with version 6.2. You can set your own picture on the frame, so the chat partner can see you. After changing the pictures few times, I had a situation when I opened the window for pic change, everything was just frozen, and I had to use Task...

I want to generate a special curve in AutoCad aproximating with little lines whith endpoints, which I've calculated in Excell spreadsheet. (example given cordinates for 150 points X,Y) I can do it drawing lines one by one what will take a long time. I know Autolisp is a way to generate a...

I have a data in array A1:A1000, where the data is in A,B,C,D E fields. Only some of the rows contain data, and it could be: or all fields are filled, or none of them. I want to copy it in VBA A:A1000, to a new location A1002, but only rows with some data written in fields. All empty won't be...

I have 2 worksheets in the workbook: 1) sheet-1 2) sheet-2 I am using VBA to do some processes in workbook. I am in sheet-2, want to copy data to sheet-1. Sheets("sheet-2").Range("A12:M1000").Copy Sheets("sheet-1").Range("A10").Select ----> Run time error Selection.PasteSpecial...

I have a 2 worksheets, FMEA, and RPN_ORDER. I want to copy all fields A10:U1000 from worksheet FMEA, to worksheet RPN_ORDER. When I made a Macro and run it alone, just for the copying and pasting, it is working. When I try to use same in the program below, the program always stops at line I...

I have an Excell file entering some records which I want to sort based on some columns. I made a program in VBA for the following: All records entered in worksheet # 1: A B C D 1 x x x x 2 y y y y . 1000 z z z z On worksheet# 2 I have a copy of worksheet # 1 ...

In conditional formatting of fields, is it possible to use bold frames for some condition? Giving the condition and choosing the Format-Border i don't see that i can choose bold type of lines. Also there is know possibility to use in Format-Fonts bold letters. Is it normal or just I don't know...

I have some data in worksheet-1. In the other worksheet-2 I am reading some fields from worksheet-1. (in the worksheet-2 I have every record-row from worksheet-1, just not all fields).I am going to sort worksheet-2 based on the value in the column B (this I am doing in VBA, the workshet is...