Search results

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 Chihiro, Thank you for your support and efforts. Ok will delete manually Kind Regards

Dear Chihiro, Thank you very much for your reply. I have attached a file wherein few named ranges are still left that is referring to external workbook even after running the code Please help to resolve the same Thank you

Dear Chihiro, Thank you very much for your reply. The code is working well and deleted the external reference but few external references as shown below is left undeleted Kindly advise

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

Dear Marc, There are more than 200 sheets Among 200 sheets, sheet name starting with AP first 2 letters is around 50 Manually we can move all these AP sheets to end, but bringing back to the original location where it is already there is not possible Trying with CodeName of the sheet Thanks

Attached is the example file Thank you

Dear Marc, It is not working, I have depicted the general concept only Or I didn't get you Sorry

Dear Marc, The code i have tried by recording Macro with added few lines is as below Sub Macro1() 'MOVE SHEETS THAT HAS PREFIX NAME STARTES WITH AP TO END OF THE SHEET 'BEFORE MOVING, NEXT SHEET NAME OF THE SHEET STARTS WITH AP SHALL BE SAVED TO USE IT LATER(in separate sheet) ' Macro1 Macro...

Dear Marc, Thank you for your reply Logic is as below Normal sheet names without having prefix AP has certain format Sheet names begins with AP and followed by any sheet name has certain format content So there are three prefix sheet name has AP1 AP2 and AP2 Required Algorithm shall be...

Dear all, Kindly advise the solution for the case We have sheets in a worksheet as below AP1sheet1 sheet2 sheet3 AP2sheet4 sheet5 sheet6 sheet7 AP3sheet8 sheet9 sheet10 AP3sheet11 [So this AP1 or AP2 or AP3 is 3 standard prefix is constant and repeated as many times as in many sheets] Need...

Thank you for your reply But the same code is working in Windows 10 if all open FOLDERS/ WINDOWS EXPLORER are closed Regards Govind

Dear All, While working in Windows 7 this code was working in Excel 2013 But this same code is not working in Windows 10 and returns ASCI code ?? Interesting fact is if 2 more windows explorer (folders) are open this error appears If the windows explorer (folders) are closed this same code is...

@Bosco, thanks a lot yeah it is working got it....

Dear Narayan, VBA code worked for me Got the generalised solution Thank you very much

Dear Narayan, Thank you for your reply. The actual requirement is for generalised requirement to extract the actual from a cell with custom formated cell Kindly advise

Dears, I have a cell A1 with custom formatting as 0.0" RUNs" if we type 10 in cell A1 then it appears as 10.0 RUNs in cell A1 Need to copy the cell A1 content and paste in say cell C1 as 10.0 RUNs as FULL TEXT so the cell content of C1 shall be 10.0 RUNs not only 10 Please advise Regards...

Thank you Hui, if it is avaiable in future version it will be more helpful...

Dears, Is there is any way to use the cell reference/ values in the equations written using the equation editor in excel? Any help please

@Chihiro Thanks a lot. It perfectly works.

But if it is required to select more than one sheet after selection it is completed Say i have selected all sheets, out of selected sheet is there is any way to deselect more than 3 sheets with specific different names? Kindly advise Thanks

@Chihiro Thank you it works for me... Regards Govind

I'm selecting to print / non print the sheets thanks

Hi I tried that code with below message Please advise