Forum

Hi Shoaib, You can use a formula for this =VALUE(TEXTJOIN("",TRUE,IFERROR(MID(A1,ROW(INDIRECT("1:100")),1)+0,""))) If your version of Excel d...

Hi Taylor, If the invoice number is in A1 try this ActiveSheet.Copy After:=Sheets(Sheets.Count) Range("A1").Value = Range("A1").Value + 1 Reg...

Hi Steve, the columns in the column chart are all the same colour because they are not touching each other. There's no need to make them differen...

Hi Steve, As always, illustrating what you are talking about saves me a lot of time figuring it out. Please provide a workbook. I'm not entirel...

Hi Steve, You can set the series colours like this Sub ChangeSeriesColours() ActiveSheet.ChartObjects("Chart 1").Activate With ActiveChart...

Hi, Please provide your workbook so we can see what you've done. Phil

Hi Branden, What do you mean by 'suppress'? In cells E11:E14, how do you want these values to 'suppress each other'? If you can provide a wor...

Hi Duraivel, I like to make things as simple as possible. I've often found that 'requirements' for a job are actually focussed on how to do someth...

Hi Louise, Where did you get these 3 files? Have you actually downloaded the course files from the top of the course page? Regards Phil

Hi Henry, I answered this qs yesterday when you emailed us. Did you not get that reply? Use the CONVERT function and you can then format...

Hi Steve, I suspect that your VBA editor is already open. When you connect the 2nd screen, Windows just displays it on the newly connected screen....

Hi, You're using a Bulletin Board System? In Excel? Without seeing your workbook I can't really picture what it is you are trying to do. I don...

Steve, Your code? Phil

I have to ask, why have you got a shape covering the sheet? Phil