Forum

David, Can't debug it without your workbook. Regards Phil

Hi David, Can you put the summary page at the start? You can have a different header for the first page. Phil

Hi Ehab, We try to help people to learn how to solve problems, so with that in mind, what have you tried as a solution to this? Have you read th...

Hi Joe, Can you please supply a workbook with some dummy data, just a few lines. It's th structure if the data that is important. If we start wit...

I'm confused. So you want to save macros, but you don't want to use the .xlsm format? If you have VBA in a file and save it as .xlsx the VBA will be...

Hi Ehab, Before I start working on a solution, can I ask what you are actually trying to do with all of these URL's? Do you plan on visiting all...

Hi David, I assume you are using a version of Excel that supports the xlsx format. If so, why are you saving files as .xls? I don't know any wa...

Hi Ehab, I just wrote an article that may help Regards Phil

Hi Dave, Here's the post Regards Phil

Hi Sal, By default, if you post in a topic you are subscribed to it for updates. Your profile shows that you are subscribed to this topic so you s...

Hi Dave, Sorry for the long delay. This was partly due to other commitments but partly due to getting this to work. I gave up on using IE. The...

Hi, You don't need VBA to do this. You can use a formula like this copied down as many rows as you need. =IF($E$4-(ROW(A2)-ROW($I$1)-1)>...

Hi, I'm not really clear on what you want to do. Is it that you want to run the macro on the sets of rows as described i.e.: 15->26 49-...

Hi Maurizio, Your code already inserts numbers into Col A as you wish, so what you need is for some code to delete a number from Col A if the data ...

Hi, What code are you referring to? You haven't provided any workbook with sample code. Regards Phil