Hi Sir,
Can u pls tell me that how to paste the value by using VBA in excel.
Eg: In the cell A5 there is a formula "=Sum(A2:A4), I want to copy and paste the answer in the format of VALUE in cell A6 by VBA code in a worksheet/workbook. Request you to help in this regard.
How to get a Msgbox() automatically(without shortcut / command button) when a value gets changed in a particular cell. eg: If the value in the Cell A3 is >= 100, A message box should appear.