Posts by Eggcel

    Re: Worksheet_Change Event - Nothing is Happening

    The change event does not work with cells linked to option buttons. You could assign a formula to another cell "=Z1" and then use the worksheet_calculate event, or assign an optionbutton#_click macro to each button.

    Re: Macro to insert a blank row after every 2201 cells below

    This assumes that your data starts in A1. Try with a backup

    Re: TextBox Value to Another Workbook

    Try this

    Re: Pull table from webpage with vba

    Is this webpage public access? You could check the box with vba and then scrape the data. If I could look at the source code and play with it, I could help you better.

    Re: Save As spreadsheet macro to different location


    See if this gets you where you are going

    Re: Excel VBA Debug Does Not work

    You could put a random letter at the top of the code, or even use


    and then save and close the workbook. When you reopen the workbook it will error on the letter(delete the letter before stepping through code) or stop at the stop command (delete stop before stepping through code) depending on which you use. Then you can use F8 to step through the code and find where the problem is.

    Re: Auto fill Vlookup formula to Last Active Cell-Multiple Ranges

    Please use code tags when posting code. check here for instructions on doing so.

    You can define the range as

    Range ("B2:B" & Cells(Rows.Count, "B").End(xlUp).Row)

    For columns with the same number of rows you can define a variable, such as

    dim lastrow as long
    lastrow = Cells(Rows.Count, "B").End(xlUp).Row

    but if the columns have varying rows you would need to specify in each like the first line substituting the column letters accordingly

    Re: Search string in Ebay and copy Url of that page

    I would like to figure out the error you get before looping the code. Try inserting this additional line

    IE.Visible = True


    Set IE = CreateObject("internetexplorer.application")
    IE.navigate ""
    IE.Visible = True
    While IE.Busy

    This will make the window with the ie.application visible. Step through the code and see if the ebay site is indeed opened and if the value in the cell is placed in the search bar. Then see if you get the same error. We may have to put a small pause after the page loads to be sure it is ready for input.