Forum

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

Hi John, This works fine for me and none of the text formatting is lost when a character is added to the beginning of the string Range("A1")....

Hi Maurizio, I'm not having any problem with this. If the cell A9 contains a date, then the formula =TEXT(A9,"DDDD") gives me the day of the week....

Hi Maurizio, I don't understand what you are trying to do then. It seemed that you were asking to extract the day from a date in ColA? Which is w...

Just copy the formula down ColB starting at B2 i.e. =TEXT(A2,"DDDD") =TEXT(A3,"DDDD") =TEXT(A4,"DDDD") =TEXT(A5,"DDDD") etc Phil

Hi Les, It's a timing issue. The VBA is working, but when you do ActiveWorkbook.RefreshAll VBA doesn't wait for the PQ query to do its thing. It ...

Hi Les, Can you provide the workbook please. Phil

Hi Kenn, I see you've cross posted this on Mr Excel and are receiving help there so I will leave you to that. Please don't cross post to other f...