Recent content by nagovind

Dear All, i have a lengthy sentence and i placed it in cell C7 Printing area is B2:AM64 as there are small cell sizes due to many reasons refer attachment Please advise the code to make the text wrap in vertically It breaks text intelligently based on the actual rendered width as per selection...

I have more than 300 sheets in a workbook. All sheets were working normally. All of a sudden Mouse scrolling in the first few sheets stopped working first 4 sheets out of 300 sheets scrolling are not working. Kindly advise Regards Narayan Govind

Thank you very much.

Dear All, Kindly advise the code to find the cells that are with the specified colour and then replace the Colour shade of a cell with the selected colour Example The Below code does the job of manually selecting the cells. How to automate the same with a code for a sheet without selecting any...

Thank you so much for your help

p45cal Thank you very much for your efforts and reply with an example If I provide input in any of the 2 cells and if I press the DELETE key in the required result cell then results are displayed If the same is automated like if the user KEYED IN any of the 2 cells the 3rd cell is to be deemed...

Dear All, Kindly refer to the below requirement. The user will enter input in any 2 of the cells. Based on those inputs from other cells 3rd cell will result as per the formula as listed. Is it possible to get this done In excel VBA? Kindly do the needful as necessary. Regards Narayan Govind

GraH - Guido Yes copy-pasting the curve works well Thank you

Hi it is only a representation Not the actual data Series 1, Series 2 Series 3 Series 4 all are having different data but follow same pattern for different person Here my request is how to make a chart in a easy way Create one series 1 Duplicate Series 1 to many that points to same data...

@vletm Kindly find attached the file for my case B and C column has the Series 1, similarly, i have series 2 in E/F, Series 3 in H/I, Series 4 in N/O Manually i have selected the range for Series 1 Series 1, 2, 3 and 4 (similarly i have 20 more) follow the SAME pattern as like Series 1 So i...

Thank you I understand that there is no programmatic way to handle this requirement as I have 10 set of such plots and I need to copy it to create another 10 set only by changing the data range

vletm Thank you for your resolution Kindly advise what version of this excel you are referring to. I'm using office 365 in windows 10 OS where I didn't see this option

Dear All, Kindly advise how to Duplicate a series within a chart I have a chart name Chart 1 with Series1 as one curve I need to Duplicate Series 1 with the same data range with the name as Series 2 in the same chart 1 Is there is any code that will do the above task Regards Narayan Govind

Yes it is from your inputs I was not aware of the hidden sheet it is created by another add-in now I found it because of your inputs I unhid from the sheet property Thank you once again

HI Found the solution From your TIPS Thanks a lot