Forum

Hi, Yes probably, but if you could supply some sample workbooks including your code and explain how the sheet name will change it would be helpful ...

Hi Rathanak, I haven't seen any email from you arrive. What browser are you using? Please try a different one and see if you can attach the wo...

Hi, Can you please supply a sample workbook with the form and code so we can have a look? Regards Phil

Hi, So you want to look inside each Excel file for a column named "Social Security Number" ? Or are you looking for an actual number? How man...

Hi ruzvmun, Not sure what you mean by a header 'Name' - a column in the files with a particular name? Or you're actually looking for the word 'Nam...

Hi Amisandip, As you found out yourself, users can 'turn on' the worksheet tabs themselves if they know how. I don't know a way to force the tabs ...

Hi amisandip, I don't understand why you want to hide the sheets. If you could describe what it is you are trying to achieve, maybe I could sugges...

Hi Amy, VBA is a programming language so you really would need to learn the language in order to use it. It's not a case of listing 'codes'. Ha...

Hi Pramod, A UDF is specific to whatever task you are trying to do, so I can't give instructions on how to write one for 'any lengthy formula'. ...

Hi justmeok, Please read this on the use of IFERROR If you post the same qs on multiple forums please say so on each forum and link to the qs. ...

Thx Sunny

Hi Toni, Here's a workbook you can use as a template. When it is opened it creates a new workbook with the next Job Work Order number in it. The...

Hi Jimmy, this article explains some more about custom formats Regards Phil

no worries, glad it works well. Phil

Hi Frans, The Print Topic plugin is now working. You'll see a printer icon towards the top right, across from the topic title. Regards Phil