Search results

Hi Narayan Thanks for this :-) Apologies it has taken a few days to get back to you - this was pretty much there - I just had to tweak a couple of statements to look at the right axes and not delete the Axes themselves as that seemed to screw the whole thing up as I still wanted to keep the...

Hi Narayan Thanks for this :-) - the macro works great - I have now run into an other issue which I am hoping you may be able to help with. The plan is to loop through the charts one by one to apply some formatting changes - changing axes, borders, gridline etc. The macro I have coded for...

Hi there I have a sheet which has a lot of charts many of which have the same name :-( Is there an easy way of renaming them to something unique so that macros will pick them up as different charts? Thanks

Thanks for that PCosta - working a treat! Colin

HI PCosta Hope everything is okay with you. I have tried to build on that macro you kindly put together for me, so I can change several chart attributes at the same time. I recorded a macro with the actions required (removing gridlines and changing axes fonts) and inserted them into the middle...

Aha!! Appreciate that PCosta :-) Colin

Hi PCosta Thanks for this. It seems to do it for the first chart and then stop. Colin

HELLO I have a large number of charts where i need to update the format e.g. remove borders, change fonts etc. Have tried to put together a quick macro based on something I found online but it hasn't worked - see file attached - you can see I am a novice at this. Sub Update_Chart() Dim cht...

Thank you - very slick. C

No problem p45cal - appreciate the help. Leave it with me for the moment if that's okay as I have another challenge right now where I would really appreciate an elegant solution (and is perhaps a clearer issue to work through :-)). I have a worksheet which has a Year To Date (YTD) Flag for 2016...

Hi There. Apologies for the incorrect use of terminolgy. The sheet I am using has a rectangle as a back ground - I was unable to upload the file including this as it seemed to make the file too big for uploading and so I cut it out. The rectangle has no hyperlink associated with it. The...

HI there. Attached a file where I have moved the offending sheet into a separate spreadsheet - the problem doesn't appear in this sheet for some reason, but I have pasted a screen dump from the main file which shows how the screentip appears randomly at the bottom of the screen. Realise this...

Apologies p45cal - I thought it may be a generic issue - the place the screen tip appears on the screen appears to be randomly either next to the picture or at the bottom of the screen. I am back in the office on Thursday and will upload a file then. Thanks for the help. C

Hi there I have an issue I am hoping you can help me fix. I have a file where I am adding screentips to hyperlinks associated with pictures. The problem is that the hyperlinks sometimes appear next to the picture, and sometimes at the bottom of the screen where it is easy to miss them. Is...

as simple as that!! Thanks again for the help jindon. Colin

Hiya Thanks for this - Works a treat :-) Apologies for the oversight, but I will then need to unhide the rows - can you also help with that? Thanks again Colin

Hi All Thanks for helping sort the previous problem I had - it's working a treat! There is another one which is similar to that which I would appreciate your help on... The file attached shows that there are a number of rows where every entry for the cell is "No Promotion". I need to be able...

Thank you everyone - all so helpful....all sorted! Colin

Hi Hoping you can help. I have a sheet where there are a number of columns which I need to hide IF there is no relevant information to display - see attached sample file. The condition is: where the entry for a given retailer in row 9 is "No promotion", then hide that column. Sure there...

Top Man PC - appreciate that - nice way to end the week - have a great one! :-) C

mmmmm... something still not working. have had a couple of goes at inputting the code but things seem to be getting worse!!! :-) Have attached a copy of the sheet for you to look at - I am sure it is very close - it is down to my lack of knowledge, not your expertise. Appreciate the help. C

Just to be really clear on this PC - the two sheets are in the same workbook - does that affect the code? Regards C

HI Tried that but it leaves me in the Table Print tab - it could be I have inserted the code in the wrong place - can you clarify what you mean by in "ThisWorkbook" object - I have inserted it in the Table Print sheet code - is that what you mean? When I run the Afterprinting routine...

All good here thank you - just back from a week in Austria which was great. Appreciate the support. C

Hi there PCosta - how's you? Thanks for that - have given it a try. The issue seems to be that I need the user to be able to use the print dialogue box in order to choose their printer, and when this code runs, it goes from clicking the print button back to the Brand Dashboard sheet. Does...