whats the difference about offset and range(x,x).cells(x,x)

23 minutes ago, bhavin said:

whats the difference about offset and range(x,x).cells(x,x)

 

• If you are following our videos properly..... we have not touched offset.....
• even told that offset will be covered in next video
• so answering at this point is irrelevant 
• For course we have to be together......  else ask in forums
• in short wait for next tutorial

Thank you

53 minutes ago, Saurabh Jain said:

• If you are following our videos properly..... we have not touched offset.....
• even told that offset will be covered in next video
• so answering at this point is irrelevant 
• For course we have to be together......  else ask in forums
• in short wait for next tutorial

Thank you

looks like you have got offended. thats not my intention.

 

nothing like that.........

The output cell is I10

The output cell is I10

Done filling names in highlighted cell. It was interesting.

Range("H4").Range("B1") 

Output Cell is I10

Sub cells_example()

Range("J10").Cells(1, 1).Value = "Usman"

Range("J10").Cells(1, 4).Value = "Usman"

Range("J10").Cells(5, 3).Value = "Usman"

Range("J10").Cells(8, 1).Value = "Usman"

Range("J10").Cells(3, -2).Value = "Usman"

Range("J10").Cells(1, -4).Value = "Usman"

Range("J10").Cells(-3, -3).Value = "Usman"

Range("J10").Cells(-5, 1).Value = "Usman"

Range("J10").Cells(-2, 3).Value = "Usman"

End Sub

Hi Saurabh,

I am able to complete the assignment but when giving range in negative integer why it is not uniform.

I meant, if we see code written for #2 & #6 ,

for# 2-> cell range is (1, 4) but for #6 -> cell range is (1, -4)

whereas I expect cell range to be (1,-6).

Hope you are able to understand my question ?