How ranges can be created ,edited and selected in MS-Excel ?Give detailed answer .?
817438
1. Select the cells you want to include in  a range.\n2. Click on the name box.\n3. Type the name for the range.\nthat's it.\n\nClicking the drop down button on the name box will list all the range names that has been created.
995507
A cell can either contain data or a formula, not both.\n\nYou will need to create a macro and assign it to the onChange event for that cell.
999231
use the Macro Recorder to code the procedure you want...then you can convert it to VBA (Visual BASIC for Applications) and edit it.
943817
[EDIT - DELETED A WHOLE BUNCH OF TEXT]\n\nthat kind of thing is complex to create in a macro form, normally the kind of thing that you'd pay someone to do because i'd imagine it's easily a couple of hours work to write all the code, test it, iron out bugs etc. there *may* be a built in function in excel to do something like this but i wouldn't have thought so - i'm happy to be proved wrong:\n\n----found on t'internet----\nA1:A10 (your list of values)\nB1:B10 (leave blank)\nC1: =A1*B1 (copy thist fomula down through to C10)\nC11: =SUM(C1:C10)\n\nNow to use Solver....\nTools>Solver\nSet Cell: C11\nEqual to the Value of: 1173.76\nBy Changing Cells: B1:B10\nSubject to the Constraints....\n(click the add button and constrain B1:B10 to Binary)\nClick [OK]\nClick [Solve]\n\nExcel will toggle cells B1:B10 between 1 and 0 until it comes up with a combination that sums to 1,173.76\n----end of instructions----\n\nit depends on the setup of your spreadsheet - if it's one huge page that's a jumble of undistinguishable invoices with no reference to who the invoices belong to, it means manually checking the results of the macro for the set of results that applies only to one 'customer'. ideally you'd want a seperate sheet for each customer and then the macro or above method can be ran on whichever sheet/customer the cheque is from.\n\ni dunno about other people on here but i wouldn't spend hours of my time creating such a thing for the sake of 10 points which aren't really worth anything - i CAN tell you that if the above method doesn't do the job that it'd mean creating a loop that will add up every possible combination of totals from the sheet then comparing it each time against the grand total until it gets a 'hit'.\n\ni can't imagine this kind of sorting being practical for huge amounts of figures, probably a list of 20 at most because you could get into some big big processing time otherwise.\n\ni would be interested in hearing anyone elses ideas about doing it?
1154342
Assuming you are using VB6 and your data is in Columns with headings on top you can do the following.\n\nPlace a Data component on your form. Its normally  the second last component in your tool box. Then place 4 text boxes on your form.\n\nclick on your Data component and change the properties as follows.\nConnect =>set to Excel 5.0 \nDataBaseName => (Brows to the excel file that has the data)\nRecordSet => Specify the page in excel eg. Sheet1\n\nNow click on each text box one at at time and change the values as follows.\nDataSource => Data1 or whatever you called your Data component\nDataField =>Select the heading for the column you want to view. Select a different one for each text box, X values and Y values\n\nNow Run your project \nBy clicking the forward and reverse buttons you can scroll through your data. Read the help menus to write the rest of your program.\n\nI hope this helps\nGood luck.
976225
Go in the Data menu, then select Validation.\n\nYou can select "List" in the drop-down menu and enter either a cell range or custom values in this format: "A;B;C" (without the quotes)\n\nGood luck!
876032
hi male24,\n\nI really have to do an edit here bcos I think besides what u need urgently you should as well try these new steps.\n\nMicrosoft Office have provided many ways for customisable short-cuts. This means u can program an entire process of work into a short-cut.\n\nHere you need to do the ffg:\n1. open a blank word document, then type in few paragraphs of words.\n2. click the TOOLS menu and point to the MACRO to select RECORD NEW MACRO\n3. In the macro name say: FONT then click ok. NB. all your keystrokes and mouse actions will now be recorded.\n4. Use CTRL + A to higlight all the page you typed, then use your mouse to select the font you want normally. and watch the whole fonts change to Times New Romans.\n5. From the TOOLS menu again, point to Macro and select STOP MACRO.\n\nThe above steps 1-5 helps you record your action that you would like to repeat using a short-cut. Now let us assign a shortcut key.\n\n6.  On any of your tool bar, right-click your mouse and watch the drop down list. right there at the buttom, select CUSTOMIZE.\n7. In the customise dialog box, under categories scroll down and select MACROS.\n8. Once u select MACROS a list of recorded macros appear to your right, there u shd find smth like this: Normal.NewMacros.FONT\n9. Select the Font macro then look under the dialog box and select the button "Keyboard"\n10.  A new dialog box opens where u'll see categories, scroll down again and select MACROS.\n11.  Select FONTS again in the box to your right.\n12.  Under the >>Press new shortcut key<<  \n13. Now type a combination of short-cut u prefer e.g: I chose: Alt + ZZ. Hold down Alt key and press ZZ and watch it appear in d box.\n14. Select the ASSIGN button and close all.\n\n\nSteps 6 to 14 allows you to assign a desired short-cut to a group of actions such as changing the whole fonts on a page to time New Romans.\n\n15. Now clear the page and paste an example of your pdf content into word doc. then simply press  (Alt +  ZZ) i.e hold down Alt key while you press Z key twice.\nThat should perform the magic.\n\n\nyou can also try these below it's ok and fast only u need to type the font you want each time the font list appears.\ngood luck.\n\n\nFor office 2000 or 2003\nHold down:  Alt key while you press  O F       << Alt + O F>>\nType: Times Ne...  then the down arrow key shd select "Times New Roman" font \nPress Enter.\n\n\n\n more      S  I   M   P  L  E  !!!!!\nIf you are using office 2007 beta\nPress Alt key then press HFF\nthen type whatever font u want or scroll down key and select.\nWith office 2007, the feature is very simple because short-cut keys appear on each menu as soon as you press the Alt key.\n\nhope that helps
1059707
As much as I know about Excel, I have never seen the ability to do that. Your best bet would be to Merge multiple Cells in 25-50. This is about the only way to get the desired effect but it isn't exactly what you want to do I am guessing.
837908
click here:http://en.wikipedia.org/wiki/Microsoft_Excel
543882
#1.  You are assuming that the active worksheet is the first one in the book .. if it's not, it will bomb ... see ActiveSheet property\n\n#2.  You are assuming that the macro/VBA is running in this book, but if the user has multiple workbooks open, this may not be the case ... see ActiveWorkbook object.  Better?  Select Workbooks by name (see Tag values independent of filenames)\n\n#3.  Font, color, bold are meaningless for a programming problem.  Omit them for future clarity in asking a question.  Less meaningless stuff we have to wade through.\n\n#4.  Cells(1,1) depends on where the active cell is, the user or your macro may be jumping to a different place than you think it is.  Has someone inserted a row or column ?\n\nI've been doing VBA for 15 years and I have no clue what you mean by "The server threw an exception" ... you mean what ?\n\nClues as to how to fix ... use named ranges and offsets.  Name a range (always relative to the range).  Offset from there.  Always select the correct window, workbook and sheet by name, not index value.  Omit needless code from your recorded macros such as "Transpose=False" ...\n\nStop recording macros and trying to make them work.  Recording is good to get you started, not for real code.\n\nAll in all, it's a very nice semi-adjusted recorded macro.\n\nI'm not dissin' on ya Partner !   ;-)\n\nThere are good habbits and there are bad.  Learn the good habbits and life will be a cake-walk.\n\nAlways define a marker cell ... typically the top/right corner of your range or table or whatever.\n\nAlways reference everything from that point.\n\nLock the worksheet to prevent users from inserting/deleting rows/columns.\n\nUsed named sheets ... not index values.  All one has to do is insert a sheet and you're hosed.\n\nSuspenders and a belt ... this is Visual Basic here ... anything can happen.\n\nHere's a useful link for you ... just understand that here, you're pretty much expected to know your stuff or be very, very concise and specific in your inquiries and responses ...\n\nhttp://www.tek-tips.com\n\nI would encourage you to look through the forums and judge for yourself before you post.\n\nGood luck.  If I can help you out, my contact info is in the Bio.  There is always more than one way to do things ... collect the best, chuck the rest !   ;-)
832923
The default format for a cell in Excel is "general."  Someone at MS decided that big numbers "generally" should be displayed this way.  Go figure.\n\n\nRight click the cell\nSelect format cells\nselect number\nselect 0 decimal points\nclick OK
550410
There are a lot of software libraries that do that:\n\nhttp://tinyurl.com/k9zah\n\nincluding some for Excel:\n\nhttp://tinyurl.com/hrda7
41383
Here, http://www.functionx.com/excel/articles/radiobuttons.htm is a tutorial on how to create exactly what you want.  For the record what you are trying to do is create something called "radio buttons" (don't ask me why they called them that).\n\nThe basic steps are to Open Excel and go to View > Toolbars > Forms and select Forms.  That's where I'll stop as the tutorial explains it much better than I could here.
142557
you would need a compiler.. I assume your writing a visual basic program..\nThe easiest to do it is to use EXCEL assuming you have excel... You have to look in the macro area in tools bar. There is a visual basic editor!\n\nBut if your planning to program a program*, you can use Microsoft Visual Studio to do so... It costs money thou! GEt an educational copy (free).\n\nThe excel way is free... if you have office excel..
952409
That is a good question needs a GOOD answer.\nYou have some tools in Excel to do this.\nTry:\n1- View > Toolbars > Forms\nand draw the object you want (Use Checkbox and OptionBox will help you alot)\nRight click on each of these boxes and go to Properties > Control where you can select the way this control controls the action.\nYou can alos use ListBox or ComboBoxes.\n2- You may need some VBA macros to complete the job\n\nI can do alot of these for you, need you to send me more info here in Y! Answers and I can promise I will help\n\nEnjoy my profile, I am the VBAXLMan
311771
Right click in any menu toolbar, it will show you the common toolbars... select the bottom option "Customize"... In the toolbars TAB look for and select "Worksheet Menu Bar" this is the one that contein file, edit, view, insert, format ....etc\n\nYou're done!\n\nPlease vote!
452391
When you create a chart, do not specify the data range with a range of cells, use a dynamic range. The range will expand automatically when data is loaded, at the top or bottom. See the Source link for several examples.