VBA MOD01 VBA Vs Excel Worksheet Fuctions

 VBA Vs Excel Worksheet Fuctions


Sub VBA_Excel_Functions()

With ShVEF


.Range("B3").Value = VBA.DateTime.Date

.Range("B6").Value = VBA.UCase(.Range("A6").Value)

.Range("B7").Value = VBA.LCase(.Range("A7").Value)

.Range("B8").Value = VBA.StrConv(.Range("A9").Value, vbProperCase)

.Range("B9").Value = Excel.WorksheetFunction.Proper(.Range("A9").Value)

    

End With

Dim myrange As Range

Set myrange = Range("A13").CurrentRegion

Debug.Print myrange.Address

Range("B11").Value = Excel.WorksheetFunction.Max(myrange)



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