Recent content by mfaisal.ce

Dears, I have an excel file with Multiple Sheets. Is it possible to make the same formatting (Column, Row lengths, Font Size. complete formatting) of all the Sheets same as any particular Sheet (Sheet Name "231103").. Actually, number of sheets are high; if i start working one by one it will...

Thanks a lot ... It worked. Regards,

Thanks a lot for the help but it is not serving my purpose. Below is the error, I have observed that the original file , if it is opened alone without any other excel being opened, it looks normal while if u open the file while any other excel file is opened, it gives the same error as shown...

Dear, I have 03 files. Each file has same format. 1. A1 cell has date with formula "=Now()" 2. Each file is linked to get the data and file is auto genertaed daily. Requirement. 1. A1 cell date to change from "=Now()" formula to date 2. Link to be disable or deleted because when the file is...

Dear, 1. Is it possible to delete the link of excel file without opening. My issue is that I have a file which has a link and I programically open it and take some data. It is giving error when it is open because the file is moved to another computer and link is not present. If I delete the...

Thanks Dear

Dears, I need to calculate number of cells in a row based on Color. Kindly guide me how to do. It is in a row not in a column . A7= Count cells in row 7 where Color is Yellow Regards, Faisal

Thanks for the help but how to trigger the module? Can you please guide Regards,

Dear, Bundle of thanks, it worked. but my question still remains the same, is it not possible to set a range with multiple find criteria. The code you suggested is perfect, consider the R302 have more than 1000 records then loop will take more time in processing as compared to find record...

Dear, Thanks for the help but i need the formula in vb script not in excel sheet. I know how to use find single Dear, Many thanks for the help but i require code in vb script and not by excel sheet. I know how to define range with 01 criteria but I am not able to make multiple criteria...

Dear, I have a file with 02 sheets, 1. Daily 2. R302 I need to find data from Sheet 2 based on DATE from Sheet 1 and fill the Column B & C in Sheet 1 if Reactor "A" else in Column E & F in sheet 1. I am trying to use the following command but unfortunately i am not able to find Two criteria...

Dear, Is there any way to send email by vb script when Excel file gets unprotected? Regards,

Dear, I solved the issue. Range("MyRange")(Range("MyRange").End(xlDown).Offset(1, 0).Row, 1).Value = "Set Value" Where "MyRange" is my defined range (eg MyRange=C:C) in Excel and "Set Value" is my desired value. Many thanks for the help, Regards,

Dear, Please review the attach file. Range is already defined "RngDis" but when i use it by code you provided, it is setting the value to the whole column C instead of only last cell. Regards,

Dear, Many thanks for the help but the above solution provided is not working. It is assigning the new value to all the column cells from 1 to last empty. I was having the same issue and could not resolve the code. I want to give value to the last non empty cell in the column. If you could...