VBA data types

Hey Friends,

I am new to VBA and was learning some basics data types. I have seen some videos where they declare

Dim A as range
Dim ws as worksheet

I know these are variable declaration but the data types i know are integer, bytes, long, double etc. So, what are these range and worksheet means. what type of declarations are these. Any input is appreciated

Thanks

.
Dim A as Range = The variable A represent a range on the sheet. Ex: Range("A1:K1")

So ... in a macro you might have something like :

Sub YourMacro()
Dim A As Range

Set A = Sheet1.Range("A1:K1")

' more code here that will affect A

End Sub



Dim ws as worksheet = The variable ws represents a worksheet.

So ... in a macro you might have something like :

Sub YourMacro()
Dim ws as Worksheet

Set ws = Sheets("Sheet1")

'more code here that will affect ws

End Sub

Thank Logit,

That make more sense now

Hi xcel. As well as data variables you can also declare objects. Range and Worksheet are two of the many object types in the Excel object model. For more info you may find this page helpful:
https://www.excelfunctions.net/excel-objects.html