VBA MOD01 GoTo Statement

 GoTo Statement


Sub Simple_GoTo()

Range("D3").Value = ""

If VBA.IsError(Range("B3").Value) Then GoTo GetOut

Range("C3").Value = Range("B3").Value

 Exit Sub

 GetOut:

    Range("D3").Value = "you have an error in the cell"

    Range("C3").Value = ""

   End Sub





Comments

Post a Comment

Popular posts from this blog

introduction to python CH 01

----------IMPORTING MODULES IN PYTHON---------------  ''' Author: Harry Licenced to: ABC Company ***********Thanks for reading********** ''' import os # importing the os module  print("Hello world") ====================================================================== ----------------PRACTICE PROBLEM SOLUTIONS---------------- PROBLEM 01 ''' This problem is a solution of Problem 1 of CodeWithHarry Practice Set! ''' # This is also a comment just like the above line print('''Twinkle, twinkle, little star, How I wonder what you are! Up above the world so high, Like a diamond in the sky.''') ------------------------------------------------------------------------------------------ PROBLEM 02  from playsound import playsound playsound('D:\\MyData\\Business\\code playground\\Python Course With Notes\\1. Chapter 1\\play.mp3') -------------------------------------------------------------------------------...
Read more

Day 02 Python - data types , Numbers , Operations , Type Conversions , f-Strings

https://repl.it/@appbrewery/ day-2-start  LEC 18 - Intro of todays goals  ================================================================== LEC 19 - Data Type 1 - Strings    Any thing Written in " "  (double Quotes) and ' ' (Single Quotes)   -----------------------------------------------------------------------------------------------------------------------  2 - Integers          # Any Whole number in programming is known as INTEGERS ------------------------------------------------------------------------------------------------------------------------ 3 - Float            3.145   ------------------------------------------------------------------------------------------------------------------------- 4 - Boolean  True False  #  First Letter should be capital -------------------------------------------------------------------------------------------------------------...
Read more

CH02

VARIABLE : --- a_122 = '''harry''' # a = 'harry' # a = "harry" b = 345 c = 45.32 d = True # d = None # Printing the variables print(a) print(b) print(c) print(d) # Printing the type of variables print(type(a)) print(type(b)) print(type(c)) print(type(d)) ===================================================================  
Read more