Forum

Hi Sunil, To attach a file click on the Attachments button below where you type you qs. Then Add Files-> Start Upload. Phil

Hi Andy, The cell with the Barcode function was set to Text format and the font was Bold. Having it Bold mean the bars weren't being read properly...

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...