Search results

Dear Mr. Agarwal, That seems best one!! You may discuss any issue on that. & If you are looking for dynamic sheet name & range consider this... https://chandoo.org/forum/threads/update-sheet-name-with-reference.37034 Let us know if we fail to fulfill your dreams.

ThrottleWorks Your statement is bit confusing. When replying to all it adds all the recipient in the mail so why need to check them in the body. So why u need to check -"latest sender details". When u use the reply to all, very first recipient in To filed is the latest sender. As Chihiro...

I think it seems difficult by formula as per the data layout.

Excel is excellent in itself and can do lot's of things but not all the things.

Pls don't duplicate the post.

Sound interesting... https://petapixel.com/2018/01/06/hdr-photography-using-microsoft-excel/

What's your goal!

Change ActiveWorkbook to Selection

Array so Ctrl+Shift+Enter B12=INDEX($B$1:$B$6,SMALL(IF($A$1:$A$6=A12,ROW($A$1:$A$6),""),ROW()-11)) & copy down.

ebjacob1978 You can do it by placing a txt/xml file on the cloud storage & then do validate the same on workbook open event which will check & store local variables in the local folder. But, It's just nothing for advance user or having the idea of code.

In addition to what marc asked! Why not to setup a table like as below so that you can easily manage it.

I think u want to shuffle question and their 4 options rest will be static.

Is this... =LOOKUP(A12,{0,40,57,71,81},{"F","C","B","A",""})

Something like this!! Option Explicit Sub change_Q() Dim q As Integer, vList As Variant, vQues As Variant, r As Integer vQues = Range("V1:V10") ReDim vList(0) For r = 11 To 74 Step 7 re: q = Application.WorksheetFunction.RandBetween(1, 10) If Not IsEmpty(vList) Then If...

yogeshp I have deleted the zip file as it contain personal information like as mobile number and address. You are not allowed to share one's privacy data without the consent. You may re upload the file after removing such things or converting them to a dummy data!

http://www.vbforums.com/showthread.php?586964-Change-Excel-Icon

https://chandoo.org/forum/threads/locking-cells-based-on-condition-of-another-cell-help-please.32891/#post-195082 https://chandoo.org/forum/threads/unlock-cells-based-on-the-other-cells-read-a-lot-of-threads-but-need-help.26257/#post-157092...

Sample pls.

Pls explain more! getting confused. Any visual sample!!

Pls upload the sample data file as well as expected output file.

Good buddy!!

I have did for Airlines cb. Pls check.

It possible and I am using too. Will share the se tomorrow.

There's always a second window for your task.Without having macro do stuff with excel and word.

There might chance that your worksheet is protected.