Understanding VBA Range Object Properties and referring to ranges and spreadsheet cells
What is a cell and a Range Object.
As Jorge G says here, https://powerspreadsheets.com/excel-vba-range-object/ , cells is probably the first thing that springs to mind when thinking about Excel. Often, cells is used very generally and imprecisely ( and occasionally very wrongly *** ). Mostly one uses “cells” as a very general term to refer to the "boxes" as you see them in a spreadsheet. Usually what you see as such is an extremely small amount of what is associated with, and can be done with, the cells. The word sticks in the mind from most people's initial experience with looking at Excel as a spreadsheet full of square boxes or cells with possibly some values in it, or seeing coloured rectangular areas etc. I will use italics where I use that or similar words generally and imprecisely. I will use bold for a specific defined Excel or VBA Object
More precisely Excel organises its cells into groups of one or more cells and stores all information about these grouped cells in what it calls a Range Object. In simple terms this is just something that stores all the information. ( There is no VBA Cell or Cells Object. There is a Cells Property, but this is badly misunderstood. I will attempt to add some clarity in the next post ***).
It follows that the smallest Range Object is that associated with a single cell.
Even for a single cell, the information associated with a Range Object is massive . It is worth taking a look at it, - see here for example: http://www.excelforum.com/showthread...11#post4551080
The Range Object is arguably the most important, the most biggest , and the most incorrectly understood Excel thing. Microsoft recently corrected some of their literature after I bombarded their various feedback parts of web sites with Comments explaining to them their mistakes and telling them it how I saw it.
What is this Post about ( points to note )
There are several ways to refer to ( or in a Object Oriented Hierarchical Programming type language we often say “to return” ) a Range Object.
This post concentrates on the 2 - 3 Main ways to refer to or "return” a Range Object in VBA by "applying" to some Object "Properties" of the type having a coordinate type argument. For a beginner, this will come across a bit vague and imprecise at this stage . A good way to think of what I am on about is to think about how you get to a point of, or an area within , a map. Alternatively think of it as similar to navigating the globe through a pair of axis at 90 Degrees to each other.
The other very important point to note at an early stage is that a Range Object can be, and is typically, associated with a single cell or a single rectangular spreadsheet area full of cells. The latter here, of all the cells within it is often referred to as a group of contiguous cells. ( In layman's terms contiguous means all of them – no spaces – none missing.. etc.).
However, more precisely defined , The Range Object is organised into one or more of such single cells or rectangular groups of contiguous cells. Each one of these is named an Area. Because of the definition of a Range Object, it follows that each Area is itself a Range Object. ( That could further be sub divided into further areas, but rarely is).
One last point here to note, is that in many ( not all ) cases the use of a variable in VBA for a Range Object in a code in this sort of from_..
Rng.
_.. is actually defaulting to the first Area that the Range Object has in its Areas list. ( It must, by definition, have at least one area ). As such, VBA effectively would "see" this in many, ( not all ), cases as the implied default.
Rng.Areas.Item(1).
The properties discussed in this post all apply to a single area, defaulting to the first area if none is given.
http://www.excelforum.com/showthread...11#post4551484 http://www.excelforum.com/showthread...11#post4551080
http://www.excelforum.com/showthread...=9#post4521752
http://www.excelforum.com/showthread...9#post4521753_
Referring to ranges in VBA ( What is a range )
As with the word cells, the word ranges is equally very loosely used. Approximately it is referring to all the cells in a Range Object, or more commonly just the first and only area thereof. So once again it is referring to the part of the Range Object which we typically "see".
Almost everything about the Range Object seems to have been designed to confuse. I expect it is based on the deep down workings of Excel. Deep down Excel has pseudo only one of anything, and what we "see" as multiple things is based on a complex system based on increments and offsets stored as sets of coordinates. Where numbers or sets of numbers match or "intercept" based on some algorithm results in our imaginary grid, aka. The spreadsheet we see in front of us.
So Excel thinking is about referring via offsets from some point.
The spreadsheet convention in Excel is fairly consistent in that it starts at, (that is to say row 1 and column 1 ( or "A" ) is), "top left" . A further very common and widely used convention is to " go along from the top left for all columns, then down to the next row, go along all columns from the left, then down to .. etc.."
In our Property discussions we are using either
_the sequential Item or Index following that convention, or
_ the row number and column number, or, mostly,
_ the default row number and column letter coordinate convention system.
By the Latter row number and column letter coordinate convention system here we are talking about the typical default Excel Address strings like "A1" for a single cell and , "B2:C3" for a cell area where "B2" is top left, and "C3" is bottom right. ( There are some other syntaxes which are "allowed" , but it is best not to use then in my opinion. As others also note, Excel is probably defaulting in such cases back to the row number and column letter or row number and column letter or Item number , and there is the risk that we may end up with inappropriately constructed references when relying on the implicit default, https://powerspreadsheets.com/excel-...ent-3096080590 ) .
_1) Range( ) type Properties
Although not defined as such, the statement Range( ) "works" generally something like a method returning the Range Object given by or referred to by the string reference argument in the ( ). As noted, we should strictly restrict ourselves with range Properties to simple Address strings in the row number and column letter notation. Other syntaxes are accepted but can lead to problems.
This Property type allows us to return a single cell, a multiple cell single area, or any combination thereof to give us a multi Areas Range Object. We have a single and double argument option.
The single argument option is the most common as we can use it to refer to all possible Range Object types. For example, we would have forms such as
_ a single cell area like Range("A1") ,
_ a single area of multiple contiguous cells like Range("B2:C3"), and
_ a multi area Range Object like Range("B2,D5:F7,G1,J1:J10,Named_Range") etc.. etc...
Range( ) type Properties are confined to "+ve directions", that is to say going to the right or down from top left
The double argument option is less common and is an alternative for, and restricted to, a single range area of one or cells. It is a "top left, bottom right" notation. So from the examples above, Range("A1") would be written Range("A1", "A1") and Range("B2:C3") would be written Range("B2", "C3"). Once again syntaxes other than row number and column letter notation are accepted but can lead to problems. ***
_1a) Worksheets Range Property
A Worksheet Object has a Property called Range. This is the Range ( ) discussed above using the row number and column letter Address notation based on "A1" being the first cell ( top left ) in the worksheet.
It is advisable to always specify explicitly the Worksheet with a code line such as_..
Worksheets("Sheet1").Range ("B2:C3")
_... rather than relying on the default worksheet taken by
Range ("B2:C3") .
Similarly using variables helps keep things well organised:
Dim Ws1 As Worksheet
Set Ws1 = ThisWorkbook.Worksheets("Sheet1")
Dim Rng As Range
Set Rng = Ws1.Range("B2:C3")
_1b) Range Range Property
That title above, Range Range, is not a typo!. ( Frequently Excel use the same word for different things which helps confuse us). Range is the Range Object and Range or Range Range is the Property explained in this section.
Having established a Range Object, such as for example, the Rng in _1a) , then the Range( ) can be used in exactly the same way once again, but this time the top left is the top left of the Range Object to which it applies
So, as example, Rng, above was the single area Range Object of the 2row x 2column cells area starting top left in the Worksheet at B2, ( and extending to bottom right of C3).
Therefore Rng.Range("B2:C2") will return a Range Object of a 1row x 2 columns cells area in the Worksheet in which Rng is in. The range starts top left at coordinate B2 relative to Address "B2" in the Worksheet. So finally the Address in the Worksheet of this new Range Object will be "C3:D3"
Once Again all types of single and multi area cells and range construction is possible, but as the referencing will again only be able to refer to cells to the right and down from the original Range Object top left, then one cannot reference any cells to the left of, or back up from top left, in this case, B2 of the original Range Object, Rng in the Worksheet.
_2) Range Item Property of a single cells area
This is currently less commonly known, mostly because it is incorrectly referred to as a cells Property.
Microsoft have changed some of their documentation following my recommendations to clarify the situation.
This is a simpler coordinate referencing convention limited to referring to a single cell.
It is more restrictive to the type, that is to say multiple cells ranges cannot be referred to, but in some of the argument options that it has, it allows “-ve and +ve direction” referring, which actually, strangely, allows for all cells in the Worksheet to be referenced , regardless of the start top left cell. ( But not with all argument options )
_2a) VBA Items and range items. ( Range Item Property single argument ( ) case )
Generally in VBA, for Objects or ( Properties) which have ( or can refer to ) a collection of similar things, the individual things can be referenced through a consecutive number or index like 1, 2, 3 .. etc.. Typically the syntax is like .Item(x), where x is usually an integer from 1 to the total Count of the similar things. ( For such an Object, the Object may be referred to as a Collection Object ).
For the case of a Range Object of a single rectangular area of spreadsheet contiguous cells , things are a bit different*. Amongst other things, this number relates to each cell in the Range Object and usually to a some outside it. The ordering follows the typical Excel Spreadsheet cells order convention of numbered from left to right and from top to bottom. *Strangely, for the case of a Range Object we may use this to reference cells outside the Range Object that lie within the Worksheet boundaries. So we are not restricted to the Items count. For the single argument option, these "Overshoot" Items follow further the typical row then column convention , so effectively we can refer to and return a single cell Range Object anywhere from top left of the original range, and extending down to the bottom of, (but not beyond), the Worksheet in a column of width equal to that of the original range
_2 b) Range Item Property double ( , ) argument case
*It is a further confusing aspect of the Range Object that for the Range Object Item Property we may also use two arguments in the ( , ) bracket representing the row, and column. If this option is chosen then we can use numbers for both, or , for the columns , the column letter (wrapped in quotations) may be used as an alternative. In the two argument case we may extend beyond the original Range Object from the top left in the Original Range Object in the usual row, column way, ( we are not restricted to a particular width as with the one argument option). Note further, that when using the two argument option for the Range Object Item Property, negative co ordinates are permitted also, and we are again not restricted to the original range . This allows us to refer to all cells in the Worksheet.... Note however:
_ the Range Object will need to have its top left far enough away from the Worksheet Top left origin such that the negative co ordinate applied does not go “further back to the left” or “further back up” than the Spreadsheet boundaries ;
_ zeros in such as this Property reference, ( 0, 0 ) , is also from the syntax valid. Such a reference will effectively go “back up, and back left” by 1 ;
_ there are no “-ve Letters” . So –ve column referencing is restricted to using column number referencing
_..
_ Returning multi cell and multi area Range Objects which contain cells back to the left or back up from top left of a Range Object can obviously be achieved by applying initially –ve Range Item Properties, followed by the appropriate Range Range Property.
The point to note here is that the range Properties return a Range Object to which one can further apply range properties
_...
The above is all, I think, that one needs to know in order to effectively refer to, and return, Range Objects using range Properties.
In the next post I try to clarify a few things that can lead to confusion ***
My mate Bill is a bit of a Tw@ - I gave him a Range object and he used the Cells property on it.
I wanted to fill my VBA variable , Ra, with the Range object associated with the single cell C3 in a Worksheet which has a VBA variable , Ws, filled with that Worksheet object thereof. I thought I would do it using one of the two main types of Range property which returns a Range object, the Range Item Property. I decided to use it in its two argument form .Item(3, 3) as that returns me the Range object 3 down and 3 across from the top left cell of the single spreadsheet cells area Range object to which the property is applied.
I thought it would be convenient to have my top left at the top left of the worksheet Ws. I thought of a couple of ways of doing that.
__ First I thought I would fill a variable with the Range object of a few cells starting at the top left of my worksheet as I could maybe think of that as an area to work in. So I used the other main Range property type for returning a Range object , the Range(" ") type. I used the one belonging to the Worksheet Object class. So I ended up with a code looking something like this
Set Rng = Ws.Range("A1:E5")' My work area
Then I used the Range Item Property to get the Range object of cell C3 like this
Set Ra = Rng.Areas.Item(1).Item(3, 3)
I simplified it a bit: - Rng defaults to the first area if I remove the .Areas.Item(1) bit, and the default property of a Range object is the Range Item Property, so .Item(3, 3) can be replaced by (3, 3)
So I ended up with
Set Ra = Rng(3, 3)
or this
Set Ra = Ws.Range("A1:E5")(3, 3)
__ My mate Bill is a bit obsessed the Cells property. So I thought I would do it again in a way to please him. I basically did the same, but used .Cells to return me the Range object of the entire cells in the worksheet. ( Note we have no Cells or Cell Object in VBA ). Here I went:
Set Rng = Ws.Cells ' My work area is now the whole worksheet area
Then similar to as before
Set Ra = Rng.Areas.Item(1).Item(3, 3)
simlified
Set Ra = Rng(3, 3)
or this
Set Ra = Ws.Cells(3, 3)
_.....
I was not too keen on using Cells, but Bill always insisted.
One day I thought I would play a joke on my mate Bill. I gave him a variable filled with the Range Object associated with the third cell in the worksheet,
Set Rng = Ws.Range( "A3")
Then I said to him jokingly, "..... take Rng and apply the cells property on that, like going 1 across and 3 down, to get my Range object, Ra..."
Bill had and a quick think, then gave me this
Set Ra = Rng.cells(3, 1)
Ha Ha ! -- laugh ..,- I nearly did ! :)_......
So I had a go at explaining it to him ...like this:
This is the full code line he has:
Set Ra = Rng.Cells.Areas.Item(1).Item(3, 1)
.Cells is returning the Range object associated with all the cells in Rng. So it is returning exactly the same Range object as the range Object to which it is applied. So it is totally unnecessary.
I then explained to him about the default area and the default Range Item property.
So his final code line should of been
Set Ra = Rng(3, 1)
He got most of it. But he still is obsessed with his cells property and left that unnecessary bit in . He even keeps telling people that he is using a property with row and coordinate arguments to give him Ra based on like Rng.cells(row3, column1) or r.Cells(n, 1) etc...
I keep trying to explain it to him but he doesn’t seem to have got the point yet...
https://msdn.microsoft.com/en-us/lib.../ff196273.aspx
_.............
Color convention broadly speaking:
Black is to do with a Range Object. It is an indication of that object or a property returning that object
Cyan is to do with properties in general in a code ( and may only appear in part of the code word which is a property)
Purple is a particular property in this case the Range Item Property
https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
https://www.youtube.com/watch?v=TW3l7PkSPD4&lc=UgwAL_Jrv7yg7WWC8x14AaABAg
https://www.youtube.com/watch?v=zHJPliWS9FQ&lc=Ugz39PGfytiMUCmTPTl4AaABAg. 91d_Pbzklsp9zfGbIr8hgW
https://www.youtube.com/watch?v=zHJPliWS9FQ&lc=UgwbcybM8fXnaIK-Y3B4AaABAg.97WIeYeaIeh9zfsJvc21iq
https://www.youtube.com/watch?v=vSjTzhoJFdk&lc=UgzTC8V4jCzDHbmfCHF4AaABAg. 9zaUSUoUUYs9zciSZa959d
https://www.youtube.com/watch?v=vSjTzhoJFdk&lc=UgzTC8V4jCzDHbmfCHF4AaABAg. 9zaUSUoUUYs9zckCo1tvPO
https://www.youtube.com/watch?v=vSjTzhoJFdk&lc=UgwMsgdKKlhr2YPpxXl4AaABAg
https://www.youtube.com/watch?v=XQAIYCT4f8Q&lc=UgwTUdEgR4bdt6crKXF4AaABAg. 9xmkXGSciKJ9xonTti2sIx
https://www.youtube.com/watch?v=XQAIYCT4f8Q&lc=UgwWw16qBFX39JCRRm54AaABAg. 9xnskBhPnmb9xoq3mGxu_b
https://www.youtube.com/watch?v=XQAIYCT4f8Q&lc=UgzgWvzV-kvC4TJ8O414AaABAg.9xnFzCj8HRM9xon1p2ImxO
https://www.youtube.com/watch?v=XQAIYCT4f8Q&lc=UgybZfNJd3l4FokX3cV4AaABAg. 9xm_ufqOILb9xooIlv5PLY
https://www.youtube.com/watch?v=XQAIYCT4f8Q&lc=UgzgWvzV-kvC4TJ8O414AaABAg.9xnFzCj8HRM9y38bzbSqaG
https://www.youtube.com/watch?v=XQAIYCT4f8Q&lc=UgyWm8nL7syjhiHtpBF4AaABAg. 9xmt8i0IsEr9y3FT9Y9FeM
https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
Simple VBA Range Item Property Demo
A quick graphic demo of Range Item Property arguments. ( Aka , as many people still think of as
Cells( takes arguments rows, columns ) Property. ( Which does not exist ) )
The full code descriptions and arguments and explanations thereof are around here:
http://www.excelforum.com/showthread...11#post4551080
and here:
http://www.excelforum.com/showthread...11#post4551509
and here:
http://www.excelforum.com/showthread...11#post4555023
An arbitrary Range object, that associated with the spreadsheet cells in a single area top left:bottom right of B3:C4 is shown highlighted in Yellow.
In each cell shown, some of the Range Item Property argument options are indicated.
This Post is intended to indicate the required syntax required in the brackets in order to use the a to refer to any cell in the worksheet in which the Range object is in.
To summarise:
We may use the VBA Range Item Property ( https://msdn.microsoft.com/en-us/lib.../ff841096.aspx https://msdn.microsoft.com/en-us/lib...ffice.15).aspx ) applied to a single Area of Range object to refer to any single cell in a worksheet. That is to say we use the VBA Range Item Property applied to a Range object to return a new Range object associated with any single cell in a worksheet.
For the Range Item Property we have different argument options available.
The syntax is based on
either
a two argument row, column coordinate system , like (1, -2) or (3, “B”)
or
a single argument sequential Item number ( Index ), like (3)
In both cases the origin is taken as top left of the Range object to which the Property is applied.
So if our original Range object variable was declared and then “filled” such_..
Dim Rng1 As Range
_ Set Rng1=Ws.Range(“B2”)
_..then we may obtain a new range object thus:
Dim Rng2 As Range
_ Set Rng2=Rng1.Item(1, 2) ’ Returns Range object associated with cell C2 in worksheet Ws ( same row, one ”to the right” )
or this
_ Set Rng2=Rng1.Item(1, “B”) ’ Returns Range object associated with cell C2 in worksheet Ws ( same row, one ”to the right” )
or this
_ Set Rng2=Rng1.Item(0, 0) ’ Returns Range object associated with cell A1 in worksheet Ws ( one “back up”, and one “back to the left” )
or this
_ Set Rng2=Rng1.Item(2) ’ Returns Range object associated with cell C2 in worksheet Ws ( one ”to the right” )
( In all the code lines the .Item can be removed as the Range Item Property is the default property for a range Object. So we could write like this:
_ Set Rng2=Rng1(1, 2)
( Often the .Cells property is included in such a code line. That is completely redundant in such a case as the .Cells Property returns the Range object of all the cells in the Object to which it is applied. So in such a code line the .Cells Property applied to Rng1 returns Rng1, but it looks nice:
_ Set Rng2=Rng1.Cells(1, 2) http://excelmacromastery.com/excel-v.../#comment-2891 ) )
To explain how we return the Range object associated with a single cell, such as like C2 or A1
( __In the screenshots below, the ( ) brackets like (1, 2) are as we would use them in a code line like we had above: Rng2=Rng1(1, 2) __)
For the two argument option, we can refer to rows and columns by numbers which can also be negative which allows this option to refer to any single cell anywhere in the spreadsheet. Every row number and column possibility is shown from code line 20. ( It is also possible to use a column letter enclosed in quotes as an alternative, but this is limited to “+ve” letters ).
All 2 argument options ( row number, column number ) | Row\Col |
A |
B |
C |
D |
|---|
1 |
Rng_Item( -1, 0 ) |
Rng_Item( -1, 1 ) |
Rng_Item( -1, 2 ) |
Rng_Item( -1, 3 ) |
2 |
Rng_Item( 0, 0 ) |
Rng_Item( 0, 1 ) |
Rng_Item( 0, 2 ) |
Rng_Item( 0, 3 ) |
3 |
Rng_Item( 1, 0 ) |
Rng_Item( 1, 1 ) |
Rng_Item( 1, 2 ) |
Rng_Item( 1, 3 ) |
4 |
Rng_Item( 2, 0 ) |
Rng_Item( 2, 1 ) |
Rng_Item( 2, 2 ) |
Rng_Item( 2, 3 ) |
5 |
Rng_Item( 3, 0 ) |
Rng_Item( 3, 1 ) |
Rng_Item( 3, 2 ) |
Rng_Item( 3, 3 ) |
For the single argument option, all Item number possibilities are shown from code line 30. We start at top left of the original Range object and follow the typical spreadsheet convention of along all columns then down to next row. We can refer to all cells in a column of width equal to that of the original Range object area, extending down to the bottom of the worksheet in this column then row convention. Effectively only positive Item numbers ( Indexes ) are possible, but strangely we have Items outside the original Range object. The alternative column letter option is also shown over the single argument ( Index) area, but note that the column letter option is also available to the right of the Index area: The complete “+ve” letter range is shown in red text
All single argument ( Index ) options
Some 2 argument ( row number, column number ) options
Some 2 argumant ( row number, column number ) options
(complete column letter option range is shown in red text | Row\Col |
A |
B |
C |
D |
|---|
1 |
Rng_Item( -1, 0 ) |
Rng_Item( -1, 1 ) |
Rng_Item( -1, 2 ) |
Rng_Item( -1, 3 ) |
2 |
Rng_Item( 0, 0 ) |
Rng_Item( 0, 1 ) |
Rng_Item( 0, 2 ) |
Rng_Item( 0, 3 ) |
3 |
Rng_Item( 1, 0 ) |
RngItm(1, "A") and RngIem( 1 ) |
RngItm(1, "B") and RngIem( 2 ) |
Rng_Item( 1, 3 ) |
4 |
Rng_Item( 2, 0 ) |
RngItm(2, "A") and RngIem( 3 ) |
RngItm(2, "B") and RngIem( 4 ) |
Rng_Item( 2, 3 ) |
5 |
Rng_Item( 3, 0 ) |
RngItm(3, "A") and RngIem( 5 ) |
RngItm(3, "B") and RngIem( 6 ) |
Rng_Item( 3, 3 ) |
_....
Simplified code:
Code:
Sub Funky2Tests2() ' http://www.excelforum.com/showthread.php?t=1154829&page=13&p=4566077#post4566077
Dim RngObj1Area As Range ' Arbritrary Test Range
Set RngObj1Area = Range("B3:C4") '
Range("A1:D5").ClearContents: RngObj1Area.Interior.Pattern = xlNone: Let Range("A1:D5").Font.ColorIndex = xlAutomatic 'Prepare demo range
Call RangeItemsArgumants2SHimpfGlified2(RngObj1Area, Range("A1:D5"))
End Sub
Sub RangeItemsArgumants2SHimpfGlified2(RngOrg As Range, RngDemo As Range)
10 Let RngOrg.Interior.Color = 65535 'mark original Range Object spreadsheet cell area
20 Let RngDemo.Value = Evaluate("=" & """Rng_Item( """ & "&" & "(Row(" & RngDemo.Address & ")" & "-" & "Row(" & RngOrg.Item(1).Address & ")" & ")+1&" & """, """ & "&" & "(Column(" & RngDemo.Address & ")-Column(" & RngOrg.Item(1).Address & "))+1" & "&" & """ )""")
30 Dim RngItmLtrRow As Range: Set RngItmLtrRow = RngOrg.Resize((((RngDemo.Row + RngDemo.Rows.Count) - 1) - RngOrg.Row) + 1, RngOrg.Columns.Count): Let RngItmLtrRow.Value = Evaluate("=" & """RngItm(""" & "&" & "(Row(" & RngItmLtrRow.Address & ")" & "-" & "Row(" & RngItmLtrRow.Item(1).Address & ")" & ")+1&" & """, """"""" & "&" & "MID(ADDRESS(1,COLUMN(" & RngItmLtrRow.Address & ")-COLUMN(" & RngItmLtrRow.Item(1).Address & ")+1),2,(FIND(""$"",ADDRESS(1,COLUMN(" & RngItmLtrRow.Address & ")-COLUMN(" & RngItmLtrRow.Item(1).Address & ")+1),2)-2))" & "&" & """"""") and RngIem( """ & "&" & "(Column(" & RngItmLtrRow.Address & ")-Column(" & RngItmLtrRow.Item(1).Address & "))+1+" & "(((Row(" & RngItmLtrRow.Address & ")" & "-" & "Row(" & RngItmLtrRow.Item(1).Address & ")" & ")+1-1)*" & RngOrg.Columns.Count & ")" & "&" & """ )""")
40 Dim RngCL As Range: Set RngCL = RngItmLtrRow.Resize(, ((RngDemo.Column + RngDemo.Columns.Count) - 1) - RngItmLtrRow.Column + 1): Let RngCL.Font.Color = -16776961
' Rem Ref
' http://excelmatters.com/referring-to-ranges-in-vba/
' https://powerspreadsheets.com/excel-vba-range-object/
' http://spreadsheetpage.com/index.php...your_vba_code/
' http://stackoverflow.com/questions/2...91641#41491641
' http://www.excelfox.com/forum/showth...eadsheet-cells
' http://www.excelforum.com/tips-and-t...eet-cells.html
End Sub
Edit 27 October, 2021-10-28 2021-10-27 05:05:17 excelfroum.com links may have changed
http://www.excelforum.com/showthread...11#post4551080 ---- https://www.excelforum.com/developme...ml#post4551080
http://www.excelforum.com/showthread...11#post4551509 ---- https://www.excelforum.com/developme...ml#post4551509
http://www.excelforum.com/showthread...11#post4555023 ---- https://www.excelforum.com/developme...ml#post4555023
