Forum

Hi Marsil, It's not exactly clear to me what you want to do. When I run the macro, I should change below cell count. so if there ability to run ...

Hi, The attached file will create a PDF for each row, but it is just saving the ActiveSheet as per your code. Is this what you want? Regards ...

No worries Alan 🙂

Hi FS, Let's use smaller numbers, all those 0000 are hurting my eyes 🙂 If we start with 10 and it increases to 11 then the change is +1. The %...

Hi FS, It depends on the percentage of which number you are calculating for. Your formula is (100000 - 110000) / 110000 Which is equal to 0....

Hi Alan, Yes you can add a file as your data source after you've created the app, but it may (will) require reconfiguring your app. I don't know...

Hi Lea, This is controlled by your Region settings in Control Panel. Your Windows may be set to English but it might be set to English (United S...

Hi Nicko, No file is attached. Regards Phil

Hi Angela, Have you read the article on implicit intersection that Mynda linked to? Because you are not specifying a column for INDEX to use in ...

Hi Chenise, As I said in the Helpldesk ticket you raised, we won't do your assignment for you but you are welcome to browse through our site which ...

Hi SC, Just use the formula I typed out above. See attached for examples in the worksheet and in VBA. regards Phil

Hi SC, You need at least Excel 2007 to use the WORKDAY function I'm afraid. Can you not get that? Phil

Hi SC, If your named range is Holidays then using the code I wrote should work. The sheet name doesn't matter. Please attach your workbook so I...

Hi Sharmita, You can use this =WorksheetFunction.WorkDay(Now(), -1, Range("Holidays")) where Holidays is a named range containing the date...

Hi Bill, No workbook attached. Regards Phil