Search results

I can get the top left corner Cell address K = Cells(ActiveWindow.ScrollRow, ActiveWindow.ScrollColumn).Address(0, 0) But unable to get the Row and column number within VBA Say K = L456 How to write a macro to scroll to the row and column which I'm unable to get If I know the row and column of...

Dear Marc L Cells(.ScrollRow, .ScrollColumn).Address(0, 0) worked for me Thank you

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?

Thank you very much.... Did this in the page layout

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

Peter Bartholomew Kindly advise how to use this macro Sub ConverToValue() [mergedCellName].Value = [mergedCellName].Value EndSub ---- This tool is doing the job but Microsoft itself is not providing the option for this...

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

Yeah that's right It is the easy way of doing it right Thank you It's done

Dear Bosco, This is working for me [<0]"FUEL"-0.00"˚";[>0]"FUEL"0.00"˚" https://chandoo.org/wp/custom-number-formats-colors/ Thank you

Dear Hui, I understand, really I forget the user from. I believe I can do it. I will try if not possible I will revert 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...

Thank you Hui, will try that way

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

Dear AliGW & Bosco, Thank you very much for your help. It's working. Regards

Dear AliGW, Please advise I have attached the excel file The input field is highly dynamic Need to extract the data - only numerical data from the input cell in the desired format as shown. Is there is any way out? please advise

Thank you, understood the concept as well

Dear AliGW, Is it possible to trim the ° Instead of -163.94° is it possible to display only -163.94 Thank you

Dear AliGW, Thank you very much, its done 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 p45cal, Thanks for your detailed reply Regards

Thanks a lot, Hui, ... Its suiting my requirements Regards Nagovind

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

Hi Chihiro, Creating Excel Addin helped a lot Thank you very much