Skip to content

Instantly share code, notes, and snippets.

@rajeevgit8055hub
rajeevgit8055hub / 4_Dynamic Copy & Paste
Created November 3, 2025 17:46
VBA_Dynamic Copy & Paste
Sub start()
'Dynamic Copy & Paste
Sheet1.Activate
'Range("A1:H1).Select
Range("A1").Select
Range(Selection, Selection.End(XlToRight)).Select
Range(Selection, Selection.End(XlDown)).Select
@rajeevgit8055hub
rajeevgit8055hub / 3_Sheets & Cell Selection.xlsm
Created November 3, 2025 16:50
VBA_Sheets & Cell Selection
Sub Start()
'Sheets & Cell Selection
Sheets("GitHub").Activate
Range("A2").Select
Selection.Value = "Gist"
Sheets("Sheet1").Activate
Range("C5").Select
@rajeevgit8055hub
rajeevgit8055hub / SQL_D1.sql
Created November 3, 2025 09:55
♻️SQL/D1🛢️of the SQL Challenge
-- Title:
-- ♻️SQL/D1🛢️of the 21 Days SQL Challenge
-- Description:
-- This script contains the SQL queries and concepts covered in Day 1 of the IDC 21 Days SQL Challenge (Restarted).
-- It focuses on basic yet powerful SQL operations — using the SELECT statement to view and filter data, and the DISTINCT keyword to find unique values in a dataset.
-- Key Learnings:
@rajeevgit8055hub
rajeevgit8055hub / 2_Variable & Data Types.xlsm
Last active November 3, 2025 16:26
VBA_Variable & Data Type
Sub Start()
'Variable Declaration
Dim StudentName As String
Dim ClassNo As Integer
Dim Age As Integer
Dim Fees As Long
Dim Discount As Double
Dim CGPA As Variant ' Decimal Value
@rajeevgit8055hub
rajeevgit8055hub / 1_VBA_Intro.xlsm
Last active November 3, 2025 16:51
My first VBA code
SUb Start()
Range("A5").Select
Selection.Value = "GitHub"
End Sub