macro add value

  1. B

    HELP!!!!! Macro does not work

    Hello Anybody willing to lend a hand? I have a button that uses the following macro: 'Ensure weights sum to 100% and are placed correctly msg = "" toolsCt = WorksheetFunction.CountA(toolsRng) weightsCt = WorksheetFunction.Count(weightsRng) Select Case toolsCt - weightsCt Case 0 If...
  2. N

    Need to pass only one value from procedure

    I need to pass the value of a variable from one procedure to another without running the entire called procedure Private Sub openReport(ByVal strProductFile as string) MsgBox "Open previous week's report.", vbOKOnly + vbExclamation, "Open" Application.Dialogs(xlDialogOpen).Show...
  3. S

    Adding a value based on time

    Hi, I would like to add a value of 7.5 every 15 days to a column with 30 rows. Please let me know if it is possible. Regards, Siddharth
  4. R

    update multiple pivot table filters containing hierarchy's based on date

    Any help on this is much appreciated!!!! I'll do my best to explain what I am looking for,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I have an excel book we use to run a quarterly report which has one worksheet for each of the company's...
  5. M

    Return Variable Value

    People I have a macro with several Userforms. And, from one of them, I calculated some values and save the result into the variable "Z", as described below: Z = Z + (Cells(Rw, colPQuantity) * Cells(Rw, colRUnitPrice)) Now, I need to capture that "Z" value using another Userform and...
  6. M

    Import Sheet

    Hey fellows, I have the code described that basically capture a sheet from another workbook and paste in the active workbook. However, the problem I'm facing is, for each column the code only import the majority data (between TEXT or NUMBER) for each column. For example, if in the column "C"...
  7. swub

    Newbie MACRO question

    I would like to have a macro that simply adds a 1 to the value of the cell selected. Not sure how to proceed. Thanks for any help & yes I did try to find using search but must not be wording search correctly.:nya:

Some videos you may like

This Week's Hot Topics