1. S

    Vba code to replace, position and remove indentation in powerpoint.

    The code works with the replace , position except with the indentation I am trying to establish Before text = 0 cm, Special = None, Alignment = Left" I have established the code below Sub changeFont() For Each aSlide In ActivePresentation.Slides For Each aShape In aSlide.Shapes Dim x...
  2. K

    Grouping by Indent using VBA

    Goal: To use a macro to group my data based on the detail information being indented. I have the following in Column A of a worksheet: Item description detail detail detail Item description detail detail detail detail detail detail Variables: The number of Item...
  3. U

    Data Validation Based on Indent?

    I have a list with over 1700 items for data validation. I am sure Excel could not handle this many items for data validation and even if it could, who would want to read through this list. My client has the list indented based on hierarchy. I need everything with an indent value of one and the...
  4. R

    VBA Formatting/Indenting

    Hi All, Wondering if someone could point me to some information on proper formatting/indentation of VBA code in Excel. I'm proficient in VBA but never learned proper formatting and my code always looks like junk compared to others. Thanks in advance, Ryan
  5. P

    Please help....bold row based on indent

    Please help write a macro that will bold entire rows based on no indentation.
  6. D

    formatting (indentation, borders) based on values of 3 cells?

    hello, i'd like to format a cell based on the values of 3 cells altogether. explanation: i have a sheet arranged in such a way that two tables can fit on a page (when printed). columns A and F have names of items, columns B and G are numeric values, columns C and H contain dates, while column...

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...