Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    21
    Views
    579

    Re: VBA - Content Banding

    Thanks once again :)
  2. Replies
    21
    Views
    579

    Re: VBA - Content Banding

    Thanks Peter for your help and support. Your code is working PERFECT :)

    In this code I just wanted the code to look at the last used row & yesterday I started a thread in which I needed the code...
  3. Re: VBA - If Target Not Intersect Till Last Row

    Thanks.... Got it:)

    I realised that in my first post I did not write that I want last used row.... instead I wrote last row.
    I should have written last used row
  4. Re: VBA - If Target Not Intersect Till Last Row

    Thanks Fluff,

    Tried your code too... Its looking beyond the last row.
  5. Re: VBA - If Target Not Intersect Till Last Row

    Thanks Joe,

    Working Just Perfect :)
  6. VBA - If Target Not Intersect Till Last Row

    Hi All,

    I am using the range A4:A100 since I do not know how to change it to look from A4 till the last row.


    Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) ...
  7. Replies
    21
    Views
    579

    Re: VBA - Content Banding

    Hi Peter,

    Sorry for a late reply. Its giving debug message because the data I have is not a table. Just normal data.

    Can't we specify a range in the code ??

    This is highlighted when degug...
  8. Replies
    21
    Views
    579

    Re: VBA - Content Banding

    All Columns of the table.




    Its Column B & its doing that perfect
    And if I am not wrong I will have to change this part of the code if I want lets say Column C to be checked for banding

    ...
  9. Replies
    21
    Views
    579

    Re: VBA - Content Banding

    Would you please let me know how to add two colors in the code

    I tried amending this part of the code


    With Rows(r).Resize(, 8).Offset(, 0).Interior .ColorIndex = c
    .Pattern =...
  10. Replies
    21
    Views
    579

    Re: VBA - Content Banding

    Thanks very much Peter for your help

    I tried changing the starting column and its just working PERFECT :)

    Thanks once again

    EDIT

    Just one more thing. Cant we use colors in the code like...
  11. Replies
    21
    Views
    579

    Re: VBA - Content Banding

    Column I

    I tried changing this part of the code and it worked fine. I tried changing 8 to 9 and it added one more column. Column H to I


    With Rows(r).Resize(, 8).Interior


    But I just...
  12. Replies
    21
    Views
    579

    Re: VBA - Content Banding

    Hi Peter,

    Thanks for the code. Its looking at the visible rows - Exactly what I wanted. Thanks.

    Please also let me know which part of the code to ammend If I want the colors to be filled from...
  13. Replies
    8
    Views
    223

    Re: Formula Assistance

    Hi CS,

    What formula are you using in Columns B & D to get due or Overdue?
  14. Replies
    21
    Views
    579

    Re: VBA - Content Banding

    Its coloring with every change in column B but its not looking at filtered rows (Visible rows). It just look at the entire data. I want the code to look at the visible rows.
  15. Replies
    21
    Views
    579

    Re: VBA - Content Banding

    Hi Fluff,

    Thanks for the reply...

    Its not working on filtered data.
  16. Replies
    21
    Views
    579

    VBA - Content Banding

    Hi,

    I am using the below code for content banding whenever a value changes in column B

    Can anybody please amend the code to look at visible rows. Like when data is filtered.


    Sub Colorize()...
  17. Replies
    9
    Views
    194

    Re: VBA - Hide Rows / Columns

    Hi,

    Thanks to everybody for the solution. All working fine.

    But I am gonna go with Fluff"s code
    Amended as per my actual ranges & using it in the worksheet change event


    Private Sub...
  18. Replies
    9
    Views
    194

    Re: VBA - Hide Rows / Columns

    Hi Trevor,

    Thanks for the reply

    As mentioned in Post # 3

    Hide Rows From 1 to 10 If values in Columns A does not equal 1
    Hide Columns From A to G If values in Row 14 does not equal 1
  19. Replies
    9
    Views
    194

    Re: VBA - Hide Rows / Columns

    Thanks for the reply Michael,

    Not working friend-

    Run-tiem error 91
    Object variable or with block variable not set


    Further I would want to hide rows and columns both
  20. Replies
    9
    Views
    194

    VBA - Hide Rows / Columns

    Hi,

    Using below code to hide rows based on column A if the value does not equal 1


    Sub hide()

    Range("A1", Range("A" & Rows.Count).End(xlUp)).AutoFilter 1, "1", , , 0

    End Sub
  21. Replies
    40
    Views
    561

    Re: VBA Code Add Condition

    I tried the code on a whole new sheet. And Its working .... Confused

    There might be some problem with my data extraction into the current sheet - I reckon. Otherwise it would not have worked in...
  22. Replies
    40
    Views
    561

    Re: VBA Code Add Condition

    As soon as I run the code - I keep on getting msg boxes. Some with Dates & some Blank Msg Box.
    When press Ok on the Msg Box - another appears


    EDIT:
    This might be the problem....
    Some blanks...
  23. Replies
    40
    Views
    561

    Re: VBA Code Add Condition

    I apologise

    Neither a code other than the suggested one is used nor any changes have been made to the code
    I have the previous code in the file with a different name which I was using & its just...
  24. Replies
    40
    Views
    561

    Re: VBA Code Add Condition

    the first line

    If .Offset(, 1).Value = "" And .Value < Date And Date - .Value > 1 And .Value <> "" Then
  25. Replies
    40
    Views
    561

    Re: VBA Code Add Condition

    When I get an error in lets say Sheet1 I control that by using the Iferror function in there for example =iferror(xxxxxxxxx),"")
    Then I copy the cell and paste (paste special values) it in Sheet2...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4