I need an expert to write a macro for microsoft excel?
101484
Take a look at the counta() command and combine it with addition in an if() formula.
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..
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!
926229
It's going to be a macro.\nFrom your Excel file, press ALT+F11 to open Visual Basic Editor\nFind "ThisWorkbook" (should be located on the left hand side) and double click on it, a new white frame should open on the rignt hand side. From there, there should be a dropdown list reading "general", change it into "workbook", and paste the code below\n\nPrivate Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)\na = Target.Column\nIf a = 1 Or a = 2 Then\n    Select Case a\n    Case 1\n        Target.Offset(0, 1).Select\n    Case 2\n        Target.Offset(1, -1).Select\n    End Select\nEnd If\nEnd Sub\n\nAs I don't know which columns you are going to use to put your data in , I have chosen A and B (or 1 and 2) if you want to change it  (say D and E or 4 and 5) modify this part of the code like so\nif a=4 or a=5 then\n\nHow does it work?\nEvery time you make changes in your worksheet, like adding data (with your scan gun),  this should call the macro, which in turn first checks if the changes occurred in column A or B and then if it's in A moves one cell to the right and if it's in B moves one cell to the left and one row down.\n\nIf it's not precisely what you want, feel free to send me an email through Y Q/R
534942
There are macro programs - search under 'macro' - which will allow you to do a key sequence for regular tasks.  Or you can learn VBA if you need to do it within Office applications (and for free:))
455573
Use the 'Help' menu of MSExcel. There is no other resource material better than the help menu of any application, especially when it is a MS application.\nAlong with it follow the article from the site www.mrexcel.com
700134
There are a lot of templates from microsoft.com under office templates.  There should be some for Excel and Word.
572733
Please check out this site it gives averything you want on VBA.\n\nwww.functionx.com
128367
There is actually a good one as a sample spreadsheet template in Microsoft Excel. there is even a better one in the older versions of Microsoft Works spreadsheet tool.
650542
I'm not an expert.... but I dont think there exist such a macro recorder in windows... but if you are good programer you can very well write a code in VB6... which will do all that for you...\nThere are many s/w available which do (most of) that for you... like system mechanic.
1005206
the same way you do it with 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 !   ;-)
93654
Macros are often used to automate repetitive tasks.  For example, I use a macro to clear all of the user input areas in Excel worksheets.  That way the sheet is ready for new data to be input from scratch.  This is much faster than clearing all cells manually, and much safer from an accuracy standpoint than entering new data into cells with old data in them.
1180456
I have found John Walkenbach's "Excel 2003 Power Programming with VBA" to best the best guide. The first 75 or so pages give a wonderful concise overview of using Excel; then he gets into actual VBA programming for the rest of the book. \n\nhttp://www.amazon.com/gp/product/0764540726/ref=nosim/104-6173268-8751955?n=283155\n\nThere are many books that give more info about "using" Excel, but for non-beginners I have always found the different versions of this book to be the best balance of the basics and VBA.\n\nI would not recommend this book alone for a rank beginner though. If you need to really learn Excel from the ground up you would need to buy 2 books, one for Excel basics and then another for VBA.\n\nWalkenbach has written many other Excel books, including one of the best overall books (for beginners to power-users) "Excel 2003 Bible."\n\nhttp://www.amazon.com/gp/product/0764539671/ref=nosim/104-6173268-8751955?n=283155\n\nThere are many other fantastic Excel authors, I own over 50 Excel books, (I guess you could call me a bookaholic, I own over 400 computer books) almost 20 of them about VBA, even though I am a lousy coder. I just find his books are some of the easiest for novices to understand, the language doesn't get too "techie."
990843
You can call it from VB6 using\nWorksheetfunction object\nthis object has all the functions in Excel\n\nenjoy\n\nXLMan
503748
http://www.independentliving.org/docs5/micro_macro.html
897637
Is there a macro hidden in it somewhere, that is running every time you open it? This is _a_ possible solution...\n\nRawlyn.