Search results for query: *

Thanks, 1726 - have looked at that but I'm only using standard colours so not sure there's anything I can do there.

I have created a spreadsheet in Excel 2013 which uses conditional formatting to identify the highest and lowest values in a (non-consecutive) range of cells within each row. The highest value cell in each row is given orange fill and the lowest is given green fill. A colleague has created a...

Thanks, Skip. So presumably I would need to get the second mailbox set up as a separate Exchange account - can this be done through a single instance of Outlook?

I have been given access to a second mailbox from which we can read and send emails - it appears as a separate mailbox within my list of Outlook accounts. What I need is for emails received from different but specific companies to be forwarded to other individuals within my organisation - for...

Something I've just noticed - when I try and re-open the amended workbook, I get the dialog asking me whether or not I want to enable macros. Usually in Excel 2007 when you open a new workbook without having Excel opened previously, the workbook just opens and you get an "Options" button up...

Thanks, PHV, but no success - it still needs to be manually unhidden the next time I try and open it.

OK, the changes all work fine and I can close and save the amended workbook with no problem. However, when I next try to open the amended workbook it is ALWAYS hidden - I have to click on View -> Unhide to get it back on screen. I've searched around online and tried a few things but here's...

PHV - many thanks, that seems to work fine. Is there anything I need to add at the end of my code to revert the security settings back to the default or will that happen automatically when I close down Excel? Skip - thanks for your replies but PHV's solution works great.

PHV - thanks, will give it a try. Skip - again, apologies if I haven't been clear but I thought that, as long as Workbook B was opened in a separate instance of Excel, I could set the macro security to a different level, i.e. disabled, while keeping the macros in Workbook A running. Is this not...

Apologies, Skip - didn't make myself clear. The second workbook is opening and the macros are running automatically, presumably because I have enabled macros in the original workbook.

Hi all, I need to roll out some changes to some template spreadsheets I developed recently. My plan was to write up an Excel macro that would ask the user to navigate to the workbook. My macro would then open the workbook, change the formulae that need changing and save the workbook back in...

Hi guys - just a quick update. Managed to solve the problem myself after some testing - basically the inserted line was falling outside the MAX_PAYMENT_LIST range so the test was always finding that the PAYMENTS_LIST range was longer resulting in an endless loop. Not sure why it gave the error...

Thanks for replying, guys. PHV - it's the insertion line that's highlighted by the debugger. I'll try your change and see if that makes any difference. Skip - aside from having to cater for different versions of Excel, I also need the list of payments to be (in theory) infinitely extendible...

Just realised that I haven't explained what my problem is!!! When the macro runs, I get the following error : "Run-time error '-2147417848 (80010108)': Automation error. The object invoked has disconnected from its clients." Thanks in advance.

I have an Excel workbook which, when opened, generates a new payment number. A macro then checks the Payment List sheet to see if the list is full. If it is, a new line is inserted below the last entry. Option Explicit Dim numPayments As Long Dim numPaymentsMaxLength As Long Private Sub...

Perfect, PHV, that works a treat - thanks! So, out of interest, do you know why my original code didn't work? Presumably .Transpose isn't compatible with one-row ranges?

Hi, I have set up a userform with a combobox that I am dynamically populating from a number of named ranges - the range used is defined by other selections made on the userform. Everything works fine if the range being used has multiple rows but a couple of them are only single entry and...

Thanks, Skip - worked a treat. Thanks also, PHV.

Skip, My code is in the OP (for some reason my delimiters didn't work!) This seems like such a simple thing to do and I can't understand what the problem is - I've tried recording a macro to do what I need and it comes up with the same code as I've used.

Thanks, both. PHV - Sheet18 is an existing sheet and I only have one workbook open. Skip - Mis-identified how?