Forum

🙂 You're welcome.

Hi Maruizio, See attached workbook for working code. You'll need to modify it to use your own data validation list. Regards Phil

Hi Nelson, Try the attached file, no VBA needed. Regards Phil

Hi, I'm not sure where these spaces are that you refer to, you haven't been clear. But if you are trying to remove spaces from the start and end o...

Hi Lydia, If you end up with 50 sheets you can save each one as a workbook using the attached VBA. Sub SaveSheetsAsWorkbooks() Dim ws As Work...

You're welcome, glad you got it sorted out. Phil

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