APPLY AND DRAG THE FORMULA IN EXCEL USING VBS SCRIPT

                              APPLY  AND DRAG  THE FORMULA IN EXCEL USING VBS SCRIPTIn this Article, we are discussing about how we can use VBS Script to Apply formula on a Excel Sheet and drag the formula down the whole column.We got different types of methods for that and they are as follows :Three Methods :M1:  Copy-PasteM2:  Fill DownM3:  Keystrokes___________________________________________________________________________________HERE :'...

Read More

                            Print Mutiplication Table From 1 to 100 on Excel Sheet *Its preferrable to use Notepad++1. Make a new Excel file with  sheet "Sheet 1".2. Make a Log file "Log.txt" for storing Logs .3.Open Notepad++ , open a new blank file and Name it say "PrintMulti1to100.vbs " . Note : ".vbs" extension and file type "All" is important to write in vbs scrpit4....

Read More