Search:

Type: Posts; User: MARK858; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.34 seconds.

  1. Re: VBA Code to Automatically Re-apply Filter

    Try


    If Worksheets("Totals").FilterMode = True Then Worksheets("Totals").FilterMode = False
    Worksheets("Totals").Range("E5:E367").AutoFilter 1, ">0", xlAnd

    Please note that it won't run...
  2. Replies
    2
    Views
    86

    Re: advanced filter - OR vs AND

    lezawang, you'll possibly find the Contextures link below easier to understand than the excel-easy link plus if you scroll down the page you can download an example workbook (see the AndOr tab for...
  3. Re: Hide rows in range when value in COL A = 0

    Hi Michael, sure not A9 rather than A10 for the header row ;)
  4. Re: Hide rows in range when value in COL A = 0

    Is filtering (either manually or with code) on doesn't equal zero an option?
  5. Replies
    1
    Views
    40

    Re: Excluding a range when copy a worksheet

    Is there any reason you can't just delete the range on the sheet between the Copy and the Save?
  6. Re: VBA Code to Automatically Re-apply Filter

    Can you explain exactly what you mean by "automatically reapply", please explain your process?

    Can you also let us know the range of your data and the range that you are applying the filter to...
  7. Re: Copy down to next row where there is data

    Just another option as I was passing through....


    Sub FillCell1()
    Dim fCell As Range
    On Error Resume Next

    For Each fCell In Range("A2:A" & Range("B" &...
  8. Re: How to include double quotation marks in a formula in vba

    You double all your quotes.
  9. Replies
    2
    Views
    53

    Re: fonts names list (range.font.name)

    If you want a list of the installed fonts then Google is your friend but as I already looked for it...

    http://excelexperts.com/show-font-list-example
  10. Re: if formula not working and showing false result

    Maybe...


    Guessing a bit because you have a stray 1000 in your post and you don't state exactly what you want the code to do.
  11. Replies
    9
    Views
    185

    Re: Calculation issues.

    It will work for the sum part.
    If you want to see why the rest is affected click E22 then on the formulas tab click trace precedents, then when you have followed the arrows, clicking the cell the...
  12. Replies
    9
    Views
    185

    Re: Calculation issues.

    You must have done changed something or the below question doesn't make any sense ;)
  13. Replies
    9
    Views
    185

    Re: Calculation issues.

    Changing the format does not change the underlying number (think of it like putting a filter over a picture, how you perceive it changes but it doesn't alter the actual picture).

    The simple way is...
  14. Replies
    9
    Views
    185

    Re: Calculation issues.

    It is because your cells are formatted to not show the decimal spaces, your values are actually...
    15.4761904761905
    15.4761904761905
    and
    7.85714285714286

    giving a total of

    38.8095238095238
  15. Replies
    5
    Views
    171

    Re: Excel 2016 color pallet number

    mark hansen



    ColorIndex is restricted to 56 color numbers.

    Run the code below on a blank sheet, what do you get as the results for the 2 different shades?


    Sub xColor()
  16. Replies
    9
    Views
    215

    Re: Adding a Minus Sign with a macros

    Currently 365 but if I get a chance over the weekend I'll see if I get the same results with 2010.
    https://i.imgur.com/eD1AgFp.jpg
    https://i.imgur.com/t3VTcDy.jpg
  17. Replies
    9
    Views
    215

    Re: Adding a Minus Sign with a macros

    Hi Rick, I put 36 in G8 and 27 in H8 and got -36 and -27 respectively in the cells with the code by footoo :confused: Can you elaborate on when you get the same number in each cell.
  18. Replies
    6
    Views
    144

    Re: VBA autofilter - filter blanks only

    Can't remember if this works after you have done a PasteSpecial (and on my phone so can't test) but what happens with...

    Sub DeleteRows()
    With Range("A:A")
    .Value = .Value
    ...
  19. Replies
    6
    Views
    144

    Re: VBA autofilter - filter blanks only

    Are you sure that your cells are truly blanks and not formulas returning "".
  20. Re: working with hh:mm:ss formats and IF statements

    No problem and welcome to the board :cool:
  21. Re: working with hh:mm:ss formats and IF statements

    Maybe (untested)
  22. Replies
    5
    Views
    85

    Re: Get Column Name from Range

    Might be worth you having a read of the article in the link below that Alan Beban wrote (reproduced on Chip Pearsons site)

    http://www.cpearson.com/Excel/cells.htm
  23. Replies
    4
    Views
    93

    Re: excel vba sheet name

    Or depending if you want to code to run anyway if the row 12 is deleted then


    Sub Delete12()
    If Mid(ActiveSheet.Name, 7, 1) = 4 Then ActiveSheet.Rows(12).Delete 'you could do away with the...
  24. Replies
    5
    Views
    85

    Re: Get Column Name from Range

    If You mean for instance the value in C1 from MyRange then


    Sub xxxx()
    Dim MyRange As Range
    Set MyRange = Application.Range("Sheet1!A2:G2")
    Debug.Print MyRange(0, 3)
    End Sub
  25. Replies
    4
    Views
    93

    Re: excel vba sheet name

    Maybe...


    Sub Delete12()
    If Mid(ActiveSheet.Name, 7, 1) = 4 Then
    ActiveSheet.Rows(12).Delete 'you could do away with the activesheet and just have Rows(12).Delete
    Else
    ...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4