![]() To avoid adding this VBA each time you work on different workbook, you can create Add-in which will run this VBA automatically when you open any excel workbook.Īll you need to do is to select the type Excel Add-in and save it in the default folder. You need to save this workbook as a Micro-Enabled workbook so then only it will work properly. ![]() When you’ll try to save this workbook, you’ll get the below error so simply click on no.Īs you are running a VBA in this workbook so you cannot save this as a normal workbook. So it will replace all the existing cell references (B2) into (B3). Add new cell reference (having numeric value) in Replace-with-box (in my case the cell reference is B3) and click on replace all. Remove equal (=) sign from beginning of formula, select the whole formula by pressing CTRL+A, click on replace, put existing cell reference in Find-what-box (in my case the cell reference is B2). You’ll need to refer cell which having numeric value many time in this formula and by doing this manually is time consuming, so you can use following shortcut to do that.Ģ. How to change multiple cell references in long formula?īy default this formula is applied on cell A1, so you can change the cell reference as per your data. In my case I have the numeric value in Cell (B3) so I will replace the formula with my cell reference. ![]() ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |