Posts by Robert B

    Re: Copy Over Information


    Hi


    and welcome to the forum


    try

    Code
    1. Dim R As Long
    2. R = Sheets("Sheet2").Range("A1").SpecialCells(xlCellTypeLastCell).Row
    3. ActiveCell.EntireRow.Copy Destination:=Sheets("Sheet2").Range("A" & R + 1)
    4. ActiveCell.EntireRow.Delete


    which will copy the current row to Sheet2 (you will need to amend the name accordingly)
    also be careful that none of the formulae in the source sheet have set ranges (i.e. those that look like $A$1)


    Hope that helps


    Robert

    Re: Copying Colored Cells


    Hi


    It souns as though there is some conditional formatting somewhere, to avoid this copy from original to target cell using Paste Special and select Formulas, or edit the conditional format on the target cell


    Robert

    Hi


    I am trying and failing to use this


    Code
    1. If (IsError(Application.WorksheetFunction.Match(StartAT, GradeArray, 0))) Then


    StartAT is a text string that might be blank or a space or other invalid entry, GradeArray is a table which I am using to get a numeric value from a valid text entry. If the entry is invalid then I will use a value from an adjacent cell.


    The problem is that I get the 1004 error.


    Can anybody shed some light on this?


    Thanks


    Robert

    Re: Copying Rows To Other Worksheets With Macros


    Hi


    try something like this


    Code
    1. Dim N As Integer
    2. Do Until ActiveCell = "" 'position cursor over appropriate cell
    3. N = ActiveCell
    4. ActiveCell.EntireRow.Copy Destination:=Sheets(N).Range("A1")
    5. ActiveCell.Offset(1, 0).Select
    6. Loop


    which assumes that the sheets to which you are copying the data are named "1","2","3" etc


    HTH


    Robert

    Re: Running Code From Workbook 1 In Workbook 2


    Hi


    have you tried stepping through Macro 3 with either WbA or WbB as the active workbook? This may identify which line is causing the problem. The only other thing that I can think of that would produce similar symptons is that you had 2 copies of Excel running, as opening a second Excel session would not allow access to macros available to the first session.


    Robert


    ADDED BY ADMIN


    Record A Macro.

    Re: Macro To Edit Chart Elements


    Hi


    it seems that there might be a bit of identification missing, based purely on previous format of your code;


    Code
    1. ActiveChart.Axes(xlCategory).Select



    should there be something like


    Code
    1. ActiveChart.Axes(xlCategory.xlSecondary).Select


    HTH but apologies if I have missed your point entirely


    Robert

    Re: Comparing And Deleting Records


    Hi


    welcome to Ozgrid


    assume the phone numbers are in Column C and the numbers for comparison are in Column D, selecting D2,try the following


    Re: Save Close Reopen Workbook & Continue Running Code


    Hi


    welcome to the forum.


    that is possible, although it does not seem to achieve a great deal, I think it might be more profitable to attempt to discover why the macro is giving an error, perhaps you could post the code that you have and maybe someone can spot the problem


    Robert


    ADDED BY ADMIN


    [GS="Copy Method of Worksheet Class failed"]*[/GS]

    Re: Hlookup Formula - Explanation?


    Hi


    it would appear that the element of the formula in bold is there to calculate the row number to be accessed in the reference range; in this instance 29. The seemingly superfluous comma would usually be followed by either "true" or "false" ( or 0 or 1), depending upon whether an exact match was required or the nearest match, in this instance it would default to 0


    HTH


    Robert

    Re: Copy Rows X Times Where Cell In Column Is Between a Numeric Range


    Hi



    Try the following



    HTH


    Robert

    Re: Vba Use Variable Inside Formula


    Hi and welcome


    do you actually need to put a formula in the activecell; could you use something like


    Code
    1. dim ID as long
    2. ID = mid(thecell,3,2) ' if the ID number including prefix varies use LEN(thecell)-2 instead of 2
    3. activecell = ID


    or have I misunderstood ytour intention?


    Robert

    Re: Filter Information From Multiple Sheets Into Master Worksheet


    Hi and welcome to the forum


    As you have found, splitting a database over a number of worksheets causes limitations when you attempt to manipulate or sort data, so I would recommend putting all your member details on 1 worksheet, unless, of course, you have more than 65k members, this will enable you to apply filters in the usual way


    Robert