Search results

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

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...

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

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

Dear All, In my workbook which I was using for many years, ended with this error Simple code used in another new workbook is working well Both worksheets are attached for reference The workbook that shows error has to be rectified as it is my original workbook with other sheets deleted Kindly...

Kindly advise any project planner available as a readymade solution to Plan the project start date, activity data, end date for one whole year in a Excel Sheet Regards Narayan Govind

Dear All, The below code is working well for a change in the cell value A1 as well as for a change in cell value C2. Change event needs to be triggered for a FORMULA result in the cell A1 and C2 not the direct entry edit in the cell A1 and C2 Please confirm this code can be used without any...

Dears, Say for example in Cell A1, after entering the 1st day of the month as 01-05-2021, I need to get A2 to A31 full month date of the particular month. i.e auto calculating the date for the date in the cell A1 Instead of dragging/ autofill, need to get the automated date. Kindly advise...

Dear All, Total working days in a week 5 days (Friday and Sat weekly off) Task1 starts at 06 09 2020---(1) Task1 needs 10 days of work Task1 ends at 17 09 2020---(2) How to get (1) + 10 = (2) excluding the dates 11 and 12 How to automate this to find the next date excluding Frid and Saturday...

Dears, Kindly advise how to fill the chart as attached The shape varies as square or rectangle as per the input data Regards Govind

Dear All, Is there is any way to add the selected cell from user form and display the result as a pop-up window itself Say A1 A2 A3 cells have data After clicking a shortcut say ctr+shft+a, window has to popup ask for number of variables to add once it is given as 3 (say, n) it has to allow to...

Kindly advise a code to bold the cell value after selecting the cell and after running a macro with a certain condition as below: Say the cells from A1 to A10 has the values as listed as below if I select the cells from A1 to A10, then after running a macro, the result shall be, the cell that...

I have a XY scatter chart Properties Locked = Unticked Worksheet protected with a password While running the VBA if we try to change the chart properties through VBA, we need to unprotect sheet by supplying password inside the VBA to do the changes in the Chart then after again protecting the...

Kindly advise how to de-select a chart using Excel VBA instead of selecting a cell to de-select an active chart Regards Govind

Please refer to the below excel cell C38 This is at the left corner Say after a macro runs it will scroll or moves, at the end of the code I need to re position the cell appearance to the same position This position is random I need to save the last cell display portion by knowing the corner of...

After opening a file, i'm getting this error How to resolve this. Why this is happening?

Dear all, How to make the same height of Rows and same height of Columns with the same unit Thank you Regards

Kindly advise is there is a way to copy the data from the merged cells that contains a formula and paste in the same cell only the values Thank you

Dears, How to format a number with -ve answer If we format a cell as below "FUEL"0.00"Deg" The result with a numerical value say 50 will be displayed as FULE50.00Deg if it is a -50 negative value then it will be displayed as -FUEL50.00Deg Is there is any way to format as FUEL-50.00Deg -Ve...

Dears, Kindly advise how to add picture/ logo in the input box in excel vba A sample file is attached Kindly do the needful Regards

Dears, Kindly advise how to extract the data in a cell to 2 different cells as shown. Kindly do the needful. Attached is the excel sheet. Regards Govind

Dear all, Kindly advise the resolution for multiple cell change event to trigger same VBA code Cell A1 Cell C2 Cell D9 If any of above cell value changes need to trigger a VBA code Thank you Nagovind

Dear All, We have created many macros for an excel sheet. How to retain it in a PC such that it will work for any open workbook. It shall be in such a way that macros will not be embedded in all worksheets. So that Created macros will be PC based and not excel workbook based Kindly advise...

Dear All, Kindly advise the code that will delete the named ranges that are external to the workbook Thank you