- microsoft excel
- microsoft solution for windows-based hosting
- microsoft robotics - visual programming language
- microsoft robotics - concurrency and coordination
- microsoft access
- microsoft excel
- sharepoint - excel services
- programming projects
- visual basic
- programming / it case studies
- .net installation and configuration issues
- visual basic .net
我想对Excel提一些建议
I confirm David's assessment. Your post is totally illegible to me."娄杰" wrote:> 我叫娄杰,来X国,现湖南岳阳读书,最 我XX电X表XExcel.当我现在对表X 了一定的了解之后,认为其X还有些 足之处,以下是愚的美芹之献,希望参 :> Excel的菜单X"窗口"X的"冻结窗X"有 点不完美之处,就是说它只能同时冻结 一行或者一列,而不能同时冻结一行一 .这X有时候很不方便.这里举一个不 当的例X吧:> 假如下面是一个电X表X的内容,它有9 9行和99列.假如现在X想知道X号是65(...
0 answers | 1732 bytes |
我想对Excel提一些建议
我叫娄杰,来X国,现湖南岳阳读书,最 我XX电X表XExcel.当我现在对表X 了一定的了解之后,认为其X还有些 足之处,以下是愚的美芹之献,希望参 :Excel的菜单X"窗口"X的"冻结窗X"有 点不完美之处,就是说它只能同时冻结 一行或者一列,而不能同时冻结一行一 .这X有时候很不方便.这里举一个不 当的例X吧:假如下面是一个电X表X的内容,它有9 9行和99列.假如现在X想知道X号是65( 第66行)的信息,X为了方便,需要冻结 一行即属性值(也即"X号"、"姓名"、" 籍贯"、...、"总分"一行).但X为了看X 号65(即第66行)的"总分"(假如"总分"是第77 列)的值(...
0 answers | 1432 bytes |
提取另一工作表整行内容
Sheet1-单元X内容在表X排列：列 B C D E F G…行 甲类 910 920 930 940 9502 乙类 610 620 630 640 6703Sheet2-单元X内容在表X排列：列 B C D E F G H I…行 定类→甲类 甲类 乙类 乙类 甲类2 人名→ X三 李四 李一 X五 李七3 1月 920 620 650 910 630 甲类 910 920 930…4 2月 620 610 610 930 920 空(不成立)5 3月 950 620 940 610 940 甲类 910 920 930…6 4月 610 610 610 610 620 空(不成...
5 answers | 440 bytes |
提取另一工作表行内容
请帮助小弟解决这个函数套用，内容 同一工作簿Sheet1-单元X内容在表X排列：列 B C D E F G…行 甲类 910 920 930 940 9502 乙类 610 620 630 640 6703Sheet2-单元X内容在表X排列：列 B C D E F G H I…行 定类→甲类 甲类 乙类 乙类 甲类2 人名→ X三 李四 李一 X五 李七3 1月 920 620 650 910 630 甲类 910 920 930…4 2月 620 610 610 930 920 空(不成立)5 3月 950 620 940 610 940 甲类 910 920 930…6 4月 61...
2 answers | 515 bytes |
поиск одной ячейки в диапазоне ячеек
Как сделать автоматический поиск одной ячейки в диапазоне других ячеек?Суть в том что бы искало в масиве столбца A, каждую яцейку столбца В, арезультат выдавало как ЛОЖЬ или ИСТИНА в столбце C...
2 answers | 208 bytes |
Z-test using excel
Hi,Not exactly an excel question but still posting here.I want to do z-test using Excel. I do have the analysis tool pak installed(along with Analysis tool-pak VBA).Being used to Canned software (The concerned tabulation software terms it asZ-Test for percentages) which tell me automatically whe...
0 answers | 1939 bytes |
ZOrder of two forms
Here's the scenario:I have two forms to display on the screen: Form1 and Form2. The Form2 isdisplayed after the user clicks a button on Form1 (which is alreadydisplayed). Form2 is automatically displayed in front of Form1. Both formsare loaded modeless (you can't load a second form if th...
2 answers | 819 bytes |
Zooming of Excel
I am creating a report using excel and i want to write/find a module thatmakes my report open up on anyones machine using excel 2000 look the same.I want it to adjust the zoom according to the users screen setting? Is thispossible? I am not sure how to do it. If anyone knows could they help i am...
1 answers | 582 bytes |
Zoombox
Dear All,I want to be able to open the zoombox on pressing shortcut (? a free one)for all cells in column R and S .ThanksFilip...
2 answers | 162 bytes |
Zoom via Macro for WorkSheet to activate?
Hi,I have more worksheet in the workboock.I wish the Application in another PC - wiht differentMonitor-resolution to opening. However in the sameworkSheet-largeness.A.) Automatlically?B.) Via macro (Button) in the defined Zoom, for all workSheet toactivate?Have I any cance?Thank you very much!We...
1 answers | 696 bytes |
Zoom value
I don't know if this helps but some of the apps I have built require, or atleast appear best with different zoom values for each sheet. During theWbk_Open event I set ScreenUpdating to False, activate each sheet and set itszoom, then continue with other code. The zoom value of each sheet rem...
7 answers | 650 bytes |
Zoom to fit the page width
Hi,I have an excel workbook with multiple sheets. It is been used on differentcomputers and I would like my workbook to zoom always to right screen width.How can I do this?I have freezed panes on top of every sheet with a background picture thathas a width of 33,52 cm. I would like to have scree...
1 answers | 735 bytes |
zoom settings
How can I copy the sheets view zoom settings of a workbook of a newwindow.as all sheets are 100%Want it to be the same as the previous window.thxs...
4 answers | 170 bytes |
Zoom Property - 1004 Error
I have a macro that takes the column widths and row heights from theworksheet I run the macro from and applies them to all the other worksheetsthat aren't named a certain name. I would like to include the zoom propertyin this macro, but I'm getting a 1004 error - Unable to set the Zoom p...
4 answers | 1504 bytes |
Zoom property
Please you know why setting the Window.Zoom property canhave no effect on an activedocumenthost?Thnak you....
0 answers | 122 bytes |
- Zoom in out - Increment 10%
- Zoom in on selected picture
- zoom in &zoom out in VBA User Form
- Zoom Function
- Zoom event
- Zoom and Scroll Form
- Zoom a range without actually selecting it
- Zoom & Autoresizing Column
- zoom problem ?
- ZipXP
- Zipping the current Excel Spreadsheet with PkZip
- Zip workbook
- Zero Values in a Pie Chart
- yyyymmdd date format
- yup.
- your opinions and help on my best sub thus far
- Home - About Us - Contact - Privacy Statement - Link Exchange - Bookmark - Map.XML - Rss.Xml
- Copyright 2001-2009 by DEVELOPERMARK.COM Information Technology Co.,Ltd All rights reserved
- 0.266