c29

  1. W

    VBA: Popup message based on scenarios

    Dear MrExcel community Challenge I would like to create VBA code that results in a popup message after particular calculations have finished (which are part of a existing VBA code). The wording of the message depends on certain cell values. The message will also have to include certain cell...
  2. O

    If-and-isblank

    Looking to populate a fourth cell based on the values in three other cells, If A29 is blank and B29 is "green" and C29 is "red" the I would like cell D29 to be "Team B" otherwise I would like cell D29 to be "Team C". I am unsure how to write this formula.
  3. B

    Need help with VBA with If Then

    This is the code Sub LoopThruBooks1() Dim p, f, s, a, r, a1, a2, a3, a4, a5 p = ThisWorkbook.path & "\All Quotes\" f = Dir(p & "*.xls*") s = "Enter Info for Quote" a = "C18" a1 = "C3" a2 = "C13" a3 = "C19" a4 = "C29" r = 1 'The row is starts on (binary)0...
  4. J

    Duplicate in different cells

    I have a large spreadsheet with duplicate entries adjacent on 2 rows is there a formula for this they are marriages and need pairing up as you can see from the reference numbers on right side are the same that I have edited. They are in pairs with the same reference...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top