Posts by SimplyCongy

    Re: Locking cell range depending on value of another cell, repeat the process for 50


    Hiya

    can you colour the cells that will have the word "Completed" into them?

    Then you could do (i've used Yellow in this example)

    Code
    Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Interior.Color = RGB(255, 255, 0) Then
        If UCase(Target.Value) = "COMPLETED" Then
            ActiveSheet.Unprotect
            Range(Target, Target.Offset(0, -4)).Locked = True
            ActiveSheet.Protect
        End If
    End If
    End Sub

    Hi,


    I've got a bit of code that populates a listbox with any filenames (.jpgs) from a specified folder. The user can then flick through the pictures that the search finds. The only problem is when the filename contains a comma. When I use the .AddItem command, it is seperating the filename onto two lines, as if it was set to comma delimited...


    Is there anyway I can tell the listbox not to do this, but to accept a comma in the item?


    Hope this is clear.


    Thanks
    SC

    Re: Lookup Part Of A Cell


    Hi


    Try something like this



    =IF(ISERR(FIND(D6,$I$6:$I9)),"XX",$J$6:$J$9)



    Where D6 is your word to look up, I6:I9 is your range to lookup in and J6:J9 is the range you want to return


    HTH
    Simply

    Re: Deleting Duplicate Rows


    Hiya,


    this one got me going... try this if you dont want to sort your file...



    HTH

    Re: Matching column data in multiple worksheets



    Hi Ima,


    I've been away, hence why its taken me a while to respond!


    Have a look at the help menu (F1) for the find property. That will tell you how to use the "lookat" function to specify whether you want an exact match or just a close one


    HTH
    Simply

    Re: Matching column data in multiple worksheets




    Hope these comments help


    Simply

    Re: Matching column data in multiple worksheets


    Hmm,


    try something like this


    its not the whole answer, but should point you in the right directions


    Simply

    Re: Drop down to select Currency type


    Should be quite easy to do with a drop down box as you suggest. Can i just check that you dont want to change the values with the currency change (e.g £1 --> $1.83) but just the formatting (£1.00 --> $1.00)

    Re: Automatic rounding


    You could use something like this...



    ... and assign the code to a button on your toolbar...