Forum

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

Sorry Dave, I am having intermittent success with the code. The problem I'm having is that once the results page is loaded and I tell the VBA to gr...

Hi, It appears to be preparing a document to print. But without the actual document, this is out of context and I'm not sure what else I can add. ...

Hi, Just concatenate the strings e.g. in C2 =A2&" "&B2 See attached. Regards Phil

Hi Sardor, In your workbook there is nothing in B1 or B2? The rest of ColB contains text, so you can't multiply that by anything. You could h...

Hi Brian, The code you pasted doesn't have any call to NOW() in it? If you are calling NOW() from your macro then just check that the cell where...

Hi Jason, Which session/module is this in? Regards Phil

Hi Dave, I think I can do this but it will take some time to code + test. I'll try to get back to you tomorrow. Regards Phil

Hi John, I've tried various things but can't achieve what you want. Reading up on it, it does appear to be a limitation within Excel. I've trie...