Sandeep Jain

Hi Saurabh,

Completed the assignment. PFB the screenshot for reference-

Hi Saurabh,

I have completed all the 3 assignments. PFB the screenshots for reference-

Exercise 1

Exercise 2

Exercise 3

Hi Saurabh,

Completed the exercise. PFB the screenshots for reference -

Hi Saurabh,

Could you please explain how to comment particular lines of code so that it won't get compile and run ?

for example- how to comment code written for "45" in below screenshot ?

Hi Saurabh,

Able to complete the assignment but getting confused in figuring out the correct cell range and ending up doing hit and trial .

Is it possible to provide a image which shows what cell range value need to select (for both Cell & Offset) while going up, down, left and right ?

Range("D1").Offset(4, 2).Value = "Hey"

Hi Saurabh,

I am able to complete the assignment but when giving range in negative integer why it is not uniform.

I meant, if we see code written for #2 & #6 ,

for# 2-> cell range is (1, 4) but for #6 -> cell range is (1, -4)

whereas I expect cell range to be (1,-6).

Hope you are able to understand my question ?

I did assignment asked regarding - MySecondMacro and it got combined with first macro

I am having licensed version of MS Office 2019 (Home & Student) but below formula's did not work-

=Table9[#Totals]

=Table9[#Headers]

=Table9[[#Data],[Q1]:[Q3]]