Friday, April 10, 2026

select random range cell copy in vba excel - copy random cell in excel macro

 Sub Macro3()

    Dim Rng As Range

    Dim randomIdx As Long

   

    ' Set your target range

    Set Rng = Range("K3:K4591")


    ' Initialize the random number generator

    Randomize


    ' Generate a random index between 1 and the total number of cells

    randomIdx = Int(Rnd * Rng.Cells.Count) + 1

    

    ' Select the cell at that index

    Rng.Cells(randomIdx).Select

     Selection.Copy

End Sub


Wednesday, April 8, 2026

How to install drupal - How to run a website made in drupal

 Add this line in settings.php

$config['system.image']['toolkit'] = 'gd';

uncomment this line(for showing error log )

$config['system.logging']['error_level'] = 'verbose'; 

Customize below code

$databases['default']['default'] = array (

  'database' => 'rni_web',              //write data base that is blank, for new installation

  'username' => 'root',

  'password' => '',

  'prefix' => '',

  'host' => 'localhost',

  'port' => '3307',

  'namespace' => 'Drupal\\mysql\\Driver\\Database\\mysql',

  'driver' => 'mysql',

  'autoload' => 'core/modules/mysql/src/Driver/Database/mysql/',

);


1) write data base that is blank, for new installation ( 'database' => 'rni_web',  )

2) after next , you will get errors  of gd than see below link

https://kapooryash.blogspot.com/2026/04/error-while-starting-my-sql-or-appache.html

3) if drupal new install than use it with that database, if website already modified or given by some other person than change database name with backup database(replace  ( 'database' => 'rni_web',  ) with other database)

How to create 3d text with CSS - 3d illustration

<style>

 .css-3d-text {

  

   

   

    text-shadow: 0px 0px 0 rgb(250,188,2),

                 1px 1px 0 rgb(245,183,0),

                 2px 2px 0 rgb(240,178,0),

                 3px 3px 0 rgb(235,173,0),

                 4px 4px 0 rgb(230,168,0),

                 5px 5px 0 rgb(225,163,0),

                 6px 6px 0 rgb(220,158,0),

                 7px 7px 0 rgb(215,153,0),

                 8px 8px 0 rgb(210,148,0),

                 9px 9px 0 rgb(205,143,0),

                 10px 10px  0 rgb(200,138,0),

                 11px 11px 10px rgba(0,0,0,0.6),

                 11px 11px 1px rgba(0,0,0,0.5),

                 0px 0px 10px rgba(0,0,0,.2);

 }


</style>

<div class="css-3d-text">3D TEXT</div>

https://www.html-code-generator.com/css/3d-text-generator 

Tuesday, April 7, 2026

Saturday, April 4, 2026

Font color change in window 11 - Font smoothing

> Open regedit.exe

> click on Computer

> Click on HKEY_CURRENT_USER

>Click on Control Panel

>Click on Colors

>Double Click on WindowText

> and change the value from 0 0 0 to 255 0 0  for red color

====================================

For font smoothing , go to

Computer\HKEY_CURRENT_USER\Control Panel\Desktop

click on FontSmoothing and change ethe value to 1

=====================================

For font change in window 11, see below link

https://www.wisecleaner.com/think-tank/585-How-to-Change-the-Font-on-Windows-11.html

=================

Computer\HKEY_CURRENT_USER\Control Panel\Desktop\Colors