শুক্রবার, ২৮ এপ্রিল, ২০১৭

How to fix "Unknown filesystem. grub rescue.." error

  1.  Switch on the laptop, wait till you get the grub rescue screen
  2.  Type ls command
  3.  It will show a list of all partitions, something like this (hd0), (hd0,msdos1), (hd0,msdos2)
  4.  You need to find the root drive for linux. So type set prefix=(hd0,msdos1)/boot/grub command
  5.  If you get an error message, try the same command with other drives
  6.  If no error message is shown then continue typing the following commands
  7.  insmod normal
  8.  normal
  9.  Your PC will now boot successfully. Now login into the linux and type the following commands in terminal
  10.  sudo update-grub (if it does not work then try sudo grub-update)
  11.  sudo grub-install /dev/sda
This should do the job.

মঙ্গলবার, ২১ মার্চ, ২০১৭

How to append something before or after any text in MS Excel

  • Step 1: Select the range in which you will add specified text.
  • Step 2: Press Alt + F11 keys in Excel and it opens the Microsoft Visual Basic for Application window.
  • Step 3: Click Insert > Module, and paste the following VBA code in the Module Window.
VBA for adding specified text at the beginning of each cell

            Sub Func()
            Dim c As Range
            For Each c In Selection
            If c.Value<> "" Then c.Value="--textToappend--"&c.Value
            Next
            End Func


VBA for adding specified text at the end of each cell


           Sub Func()
           Dim c As Range
           For Each c In Selection
           If c.Value<> "" Then c.Value=c.Value & "--textToAppend--"
           Next
           End Func