Sandeep Jain
-
Posts
9 -
Joined
-
Last visited
Sandeep Jain's Achievements
-
VBA Tutorial 13 : For next Loop
Sandeep Jain commented on Saurabh Jain's blog entry in VBA Macros - Excel Programing's Tutorials
Hi Saurabh, Completed the assignment. PFB the screenshot for reference-
-
VBA Tutorial 11 InputBox & Message Box
Sandeep Jain commented on Saurabh Jain's blog entry in VBA Macros - Excel Programing's Tutorials
Hi Saurabh, I have completed all the 3 assignments. PFB the screenshots for reference- Exercise 1 Exercise 2 Exercise 3
-
VBA Tutorial 9 : Data Types and Variables
Sandeep Jain commented on Saurabh Jain's blog entry in VBA Macros - Excel Programing's Tutorials
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 ?
-
Tutorial 6 : Offset Property : Excel VBA Programming
Sandeep Jain commented on Saurabh Jain's blog entry in VBA Macros - Excel Programing's Tutorials
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 ?
-
Tutorial 6 : Offset Property : Excel VBA Programming
Sandeep Jain commented on Saurabh Jain's blog entry in VBA Macros - Excel Programing's Tutorials
Range("D1").Offset(4, 2).Value = "Hey" -
Tutorial 5 Working with Range Object
Sandeep Jain commented on Saurabh Jain's blog entry in VBA Macros - Excel Programing's Tutorials
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 ?
-
Tutorial 4 : Walk through VBA Editor and your second program
Sandeep Jain commented on Saurabh Jain's blog entry in VBA Macros - Excel Programing's Tutorials
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]]
