Let's Play with Excel

by Anurag Pandey

Two of 51 Macros from this book are given below: Macros to Encode and Decode the Sheet[Please check both the Macros by copying into VB Editor of Any Excel file. Then RUN the Macro.]

Sub Encode_the_Sheet_Selected_Rows_N_Columns()
On Error GoTo ERR
Dim S1, S2 As Variant
Dim change(20), CHANGE2(20), l, M As Integer
Dim ic, lc, ir, lr, hello, J, k As Long

For I = 1 To 20
If I change(I - 1) = I * I
CHANGE2(I - 1)...

• Format: Paperback
• Language: English
• ISBN: B094NZL1YH
• ISBN13: 9798502654241
• Release Date: May 2021
• Publisher: Independently Published
• Length: 216 Pages
• Weight: 0.65 lbs.
• Dimensions: 0.5" x 6.0" x 9.0"