Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    2
    Views
    82

    Re: VBA Help - Auto Hide Row

    Hello Try Below Code Paste it on Sheet Module Assuming Your Criteria Column is "C"

    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Dim i As Integer
    Dim rng As Range
    lr...
  2. Re: What have i done wrong with this macro, code wont work?

    Please Provide Some Sample Data and Details what actually you want to do ?
  3. Re: Cut a row from one sheet and paste it into another based on a specific criteria

    try below code



    Sub Test()
    Dim i As Integer
    Dim j As Integer
    Sheets("Learners").Select
    For i = 2 To Cells(Rows.Count, 20).End(xlUp).Row
    If UCase(Cells(i, 20).Value) = "COMPLETED" Then
  4. Re: How would I insert a value to a Cell with the row number of 'I'?

    see below code



    Sub Test()
    For i = 1 To 10
    Cells(i, 2).Value = Cells(i, 1).Value ' it will copy column A value to column B till row 10
    Next
    End Sub
  5. Replies
    1
    Views
    160

    Re: Excel Function in VBA

    TRY BELOW



    Private Sub CommandButton1_Click()

    If Month(Now()) = 1 Then
    Call CreatePivotTableJan
    Call CreatePivotTable2Jan
    Call AutoFit
  6. Replies
    5
    Views
    3,612

    Re: VBA Help with subtracting columns

    can you please post your data what you have in you column C and O

    post some sample data
  7. Replies
    5
    Views
    3,612

    Re: VBA Help with subtracting columns

    try below code



    Sub Substract_Column()
    Dim i As Integer
    For i = 1 To Cells(Rows.Count, 3).End(xlUp).Row
    Cells(i, 19).Value = Cells(i, 3).Value - Cells(i, 15).Value
    Next
    End Sub
  8. Re: [need vba] transpose data to multiple column into one column

    hi may be this help you

    before macro

    Sheet1


    <colgroup><col style="font-weight:bold; width:30px; "><col style="width:51px;"><col style="width:71px;"><col style="width:126px;"><col...
  9. Re: how to return set a cell value equals to last non-blank row number?

    pls give some more example not getting what you actually need
  10. Re: Automatic Macro Running when Workbooks Open

    try like below


    Sub Auto_Open()
    'your code here
    End Sub
  11. Re: Combining IF, OR and And formula to return a value

    hi try below

    =IF(AND(OR(I1="manual",I1="committee"),P1<>0),"Investigate","")
  12. Replies
    4
    Views
    155

    Re: Min indext match formula please help

    Thank You So Much Weazel
  13. Replies
    4
    Views
    155

    Re: Min indext match formula please help

    Hi Any one can help on this ?
  14. Replies
    4
    Views
    155

    Re: Min indext match formula please help

    Can Any Body Please Help On This its Very Urgent please
  15. Replies
    4
    Views
    155

    Min indext match formula please help

    Hello All,

    Please see below table i want min value i have put manually but how to get using index match formula i have tried lots of formula but not getting any single formula to get this i used...
  16. Re: Compare Each Cell in Columns (with some alternates) and format cell, if condition is met (True)

    ok just change

    this line


    If Cells(x, l).Interior.ColorIndex = xlNone Then Cells(x, l).Delete Shift:=xlUp

    to this
  17. Re: How to change formatting of text in a cell

    Very Nice Rick Sir :rofl: its really amazing
  18. Replies
    16
    Views
    1,020

    Re: Extract after symbols

    Yes Mr. Rick this code i have seen in your post before some few month and you have provided solution how to text to column using Formula so i found your code is very useful and i have never seen...
  19. Replies
    16
    Views
    1,020

    Re: Extract after symbols

    Thanks for your feedback

    Glad we could help

    Your Welcome :)
  20. Re: How to change formatting of text in a cell

    select your Range where you want to run this code and run below code



    Sub Test()
    Dim cell As Range
    For Each cell In Selection
    cell.Value =...
  21. Replies
    16
    Views
    1,020

    Re: Extract after symbols

    TRY LIKE BELOW

    <b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #BBB"><colgroup><col...
  22. Replies
    16
    Views
    1,020

    Re: Extract after symbols

    UDF IS VERY EASY TO USE just do following

    right click on sheet tab one vb window will open go to insert menu and insert module and one white screen will appear just paste my code there and save...
  23. Re: How to change formatting of text in a cell

    how many columns you have and in which column you want to run this code ?
  24. Replies
    16
    Views
    1,020

    Re: Extract after symbols

    and if you dont want to use that 1,2,3,4 as a helper you can try like below too

    <b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px...
  25. Replies
    16
    Views
    1,020

    Re: Extract after symbols

    try below udf


    Function ExtractAfterSymbol(c As Range, l As Variant)
    ExtractAfterSymbol = Mid(Split(c)(l - 1), InStr(1, Split(c)(l - 1), "=") + 1, 99)
    End Function


    after that you can...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4