Posts by aturnon

    I want to make a cell validated so that a user can only enter a value that is either below -0.1 or above 0.1.

    This is not necessary the next but is desirable to set a maximum of 999.99 and -999.99.

    Thank you in advance J

    Re: Continue Finding

    I don't think i explained it correctly.

    I type it say Mark in N3. It then looks in column B finds mark and selects the cell in column A where Mark is found in Column B.

    However i want it to be able to click my button again and it'll select the next cell that has Mark in Column B. If you get what i mean

    I have this vba code and i want it to carry on finding the next cell with the same value, so every time i click the button it'll find the next cell with the same value. E.g. i type in mark it'll find the first Mark, then click again it'll find the second Mark and so on

    I want a macro to select the cell with i type. Like i type in cust-0001 and it selects the cell which has cust-0001. I then want it to select the cell in column C that is in the same row with that value. E.g.

    Find cell in column A with value cust-0001 and then select the cell in column B in the same row.

    I don't know how to tackle this in excel vba using a macro

    I want to force the first letter of each cell in Column A to uppercase until it reaches a blank.

    I appreciate the help in advance to your replies

    I want to select the cell under the last cell of a particular worksheet and use the filldown function

    This is the code i am tryin to use but won't work

    Worksheets("CD").Range("A1").End(xlDown).Row + 1.Select

    If anyone has any ideas it would be much appreaciated.

    Here is the code i am using:

    Range("A:I").AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Range( _
            "O14:O15"), CopyToRange:=Worksheets("Report2).Range("A19"), Unique:=False

    I am basically trying to advance filter data on worksheet "Custpercust" and i want to filter it to another worksheet, which is "Report2".

    Here is the code i am using:

        Selection.PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone, _
            SkipBlanks:=True, Transpose:=False

    Basically S:Y is where data is advanced filtered, so i cannot pick a specific row size e.g. S1:Y2000

    I want to copy data in columns S:Y until blank and then paste it A19 on another worksheet. The problem is i cant copy S:Y and paste it at A19 only at A1 i can paste it. Help would be much appreciated

    Basically i have a worksheet called "Bookings".
    In that worksheet the cell A3 contains a cell value, which i change often, such as B3, B4, G5, F6, etc

    I want a macro that will use the value i typed in A3 as the range
    so something like


    If you get what i mean. I don't know how to tackle it, i need a way to refer to a range as a value in a cell.