Forum

Hi Mohamed, No file is attached. Regards Phil

Hi John, The Worksheet_SelectionChange was still executing when you selected cells on the Bidder Profile sheet. This was causing sheets to be hidd...

Hi Andy, This is not code I wrote so I do not know how it works. With regards to it changing as the data changes, it is doing this for me so not s...

Hi Katy, You have a couple of lines of code referring to your table: ActiveSheet.ListObjects("ESDCheckForm").ListRows.Add Set Table1 = Active...

Hi Katy, When I try to download your file I'm getting an error saying it's corrupted. Please attach to your reply and remove the spaces from the...

Hi Vivian, Add it here. Click on the Attachments button below (it appears after you start typing your reply) - then Add Files -> Start Upload. ...

Hi Reshera, I can only give you generic code without seeing the actual site. This worked with a dummy HTML file I created. Option Explicit '...

Hi Jonathan, Please supply your workbook so we don't have to recreate everything. Thanks Phil

Hi, Please supply your workbook with the code so we can test things in context with your data. Also, I don't know what you mean by its run time ...

Hi Reshera, What website are you trying to get this from? Phil

Hi Robert, yes and do the same for the B column: =AND($B2=TRUE,OR(RIGHT($A2,3)=".wa",RIGHT($A2,3)=".oa",RIGHT($A2,3)=".sa")) Cheers Phil

Hi Chadi, These articles describe how to do what you want There are also a few topics on scraping in this forum where I've written code whic...

Hi MM. Excel uses its own internal names for the sheets e.g. Sheet1, Sheet2. If you change the names on the sheet tabs in your workbook, these int...

Sorry, Access is not my strong point so I'm not sure what to suggest to make it work for you. Regards Phil