Forum Discussion
Two similar VBA Excel code
Here are two VBA property codes on the RANDE that mean the same thing: Range("A1:A10").Value = 99 Range(Cells(1, 1), Cells(10, 10)).Value = 99 In which case the second one really had to be used? ...
I am assuming the second line was to read as below if they were to match.
Range(Cells(1, 1), Cells(10, 1)).Value = 99
Using Range with Cells would typically be used when one of the properties of Cells is to be a variable, easy enough to do "A" & i however if we wanted a variable for the row number but it becomes messy if we want the Column letter to be a variable, much easier to work with integers as variables using Cells with Range vs. using letters with Range without Cells.