Recent content by NeverHappyMike

Hi I recorded my actions using the macro recorder, and that was the code it gave me as an output. I'm copying a legend, which is actually just an image, from one set of panel charts that share this legend, to another workbook with the same panel chart layout and series but different data. The...

Hi I tried it, and exchanged the sheet1 to simply (1), as that's all my workbook/s have. But it gave me an error message on the part: SO.Shapes.Range(Array("xlamLegendGroup")).Select Saying the item with the specified name wasn't found I'm wondering if just from looking at it whether it's not...

Hi I've recorded myself copying a legend from my correct workbook (Mike1) into another one (OtherWorkbook) that I have opened. I'll be doing this process quite a few times so wanted to make a short macro to help me do this. Unfortunately, the 'OtherWorkbook' name is very specific, and I can't...

Thank you Narayan, I'll have a look into the additional column (hidden obviously). Best Mike. [Update] It worked a charm. I simply added 100% into one cell next to my top row of numbers. Selected the whole range and then chose data bars. The formatting/length of the bars was correct 50.4% was...

Hi My question is: Any ideas what I would need to change to make the conditional format data bar size represent the cell number compared to 100%? Rather than compared to the highest number in the range of numbers? I was trying to make a table full of numbers look more...useful. So I thought I...

Hi Luke. I've used your amended original code and it works great. It's done exactly what I tried to explain. I didn't try your alternative code because I fear it's actually looking for a table heading (.SpecialCells), whereas the files I am working on have make-believe headings, as they are...

Hi Luke. Yep, it was something. I simply pasted your code in and ran it. Unfortunately there are some strange outcomes. I've uploaded a file I ran the macro on, and highlighted (yellow) where it pasted the values, compared to where I thought it would (green). I also received this...

Hi I'm updating multiple sheets that contain the same structure - 4 tables, one below the other, numbered rows from 50-250 and 7 columns. Above each table is a slightly different title, but each table has the same column headings. (see attached file) I had recorded myself using the find and...

Narayan. Wonderful. It does exactly what I was failing to do. Looking at how you've done it I realise that my aspirations were well above my abilities. Thank you so very much. And also a big thanks to Chandoo's forum. Mike.

Hi Narayan Nailed it. As both tabs are the same structure I only highlighted the first one. I'm looking to find the number 14 in Column A and use the row it is in to help me make a selection that goes from $C$5:$F[Number 14 row number]. I have a macro that already does everything I need it...

Hi Narayan I've attached a file. You'll see I've highlighted the condition in column A (number 14) that will allow me to use that specific row number to create an appropriate range (yellow cells). This range would then be formatted with a certain number format. This number format can only...

Hi I'm working through multiple, and slightly different sheets, and trying to select a range based on a condition in a column that will not be part of the final range. I would then format the numbers within my final range. Column A = contains number "14". (Row n) Final range = $C$5:$F(n)...

Thanks Colin. I was wondering why a simple ',' would cause the problem.

I think I cracked it. I needed to remove the stray ', ' in the first part of RIGHT(L13,).

Hi I've a list of country names with * at the end of some them. This list is generated each year, and some country's lose the * depending on the year. I'm going to extract data from each year using INDEX/MATCH so I need to remove the * at the end of each country. I've found and tried this...