in
All Tags » VBA » formula (RSS)

Browse by Tags

  • simple vba or excel formula

    I want to be able to count different data corresponding to numbers in a column. e.g - some basic data SECTION PART # 1 abc505 1 abc505 1 abc303 1 abc303 1 abc123 1 abc505 1 abc505 2 abc505 2 abc505 2 abc303 2 abc303 2 abc123 2 abc505 2 abc505 i want a formula that will count how many abc505's i have...
    Posted to Miscellaneous (Forum) by microsoft on 05-07-2010

  • substitute formula to VBA

    hi need help with substitute the formula below using VBA =IF(K3>0,(K3-E3)/E3*100,"") tnx choni
    Posted to Miscellaneous (Forum) by microsoft on 04-29-2010

  • Combine mutiple worksheets into one workbook

    There are similiar answers on EE (e.g. http://www.experts-exchange.com/Q_24186953.html ). I have several workbooks each with one worksheet. Each worksheet has the same name as the file. I would like all of the workbooks in a given directory to be in the same workbook, using the same worksheet names as...
    Posted to Excel (Forum) by microsoft on 12-04-2009

  • Combine multiple workbooks into one sheet

    Hello, I have about 100 excel spreadsheets that I would like to combine into the same worksheet. Column headings are the same except for one. FID_TCK_ The numerals after "FID_TCK_" will be different for each spreadsheet. Can this be done? Annotated code is appreciated. Thanks, JE
    Posted to Excel (Forum) by microsoft on 09-30-2009

  • Excel macro to delete first column of all workbooks in a directory

    Hello, I'd like a macro to delete the first column of all workbooks (all one sheeted, varying names) in a directory. I suppose if it was wasn't a 'batch' macro it would start like this, right? Sub DeleteColumnA() Columns("A").Delete End Sub Obviously I need some help, Thank...
    Posted to Visual Interdev (Forum) by microsoft on 09-15-2009

  • Excel VBA : How to edit/change a formula in a cell using Excel VBA ?

    Hi, Would like to ask how to edit a formula in a cell using Excel VBA. For example, the cell A1 contains formula "=B1+C1" and I would like to use VBA to edit/change it to "=B1+C1+D1+123" Would anyone can help ? Cheers Stanley
    Posted to Excel (Forum) by microsoft on 08-14-2009

  • Excel - Calculate Hours Worked - more detailed

    I am developing an excel timesheet for my organization. I have two units A and B Unit A : -------- Work Start Time : 9:30 AM Work End Time : 7:00 PM Tea Break Time 1 : 11:45 AM Tea Break Time 1 : 12:00 PM Lunch Start Time : 1:30 PM Lunch End Time : 2:30 PM Tea Break Time 2 : 5:00 PM Tea Break Time 2...
    Posted to Excel (Forum) by microsoft on 08-03-2009

  • [ EXCEL ] Storing a cell formula in VBA

    In VBA I want to grab a formula in a cell of my worksheet, save it in a string so that later I can affect it to an other cell,I'm unable to grab the formula and if i put it staticly in VBA it always put a space in front of my equal sign so it see's it like text. I don't want to do a: Range...
    Posted to Microsoft Office (Forum) by microsoft on 07-10-2009

  • How To use an array formula in vba or Subtotal command

    I have a list of items that i need to break into groups and underneath each group calculate the most occuring piece of text in a particular column. I have been kindly given the code to use an array formula that does this, but only over a given range. If i have used the subtotal tool in excel is it possible...
    Posted to Excel (Forum) by microsoft on 06-13-2009

  • Formula vs. Value in VBA

    When I run a macro, I'd like the code to run a formula and insert it's value into a cell. (If I were doing this by hand, I would copy --> paste values). How do I do that? This is what I have now, but the formula is in the cell not the value: Cells(2, 4).Value = "=SUMPRODUCT((AllData!E2...
    Posted to Excel (Forum) by microsoft on 06-12-2009
Page 1 of 2 (14 items) 1 2 Next >