Tutorial 5 Working with Range Object Entry posted by Saurabh Jain April 14, 2020 1,657 views Share More sharing options... Followers 1 Download file for exercise 1
bhavin 1 Posted April 19, 2020 whats the difference about offset and range(x,x).cells(x,x) Quote Link to comment
Saurabh Jain 49 Posted April 19, 2020 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 Quote Link to comment
bhavin 1 Posted April 19, 2020 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. Quote Link to comment
Kashmira 1 Posted December 27, 2020 Done filling names in highlighted cell. It was interesting. Quote Link to comment
Usman 0 Posted December 27, 2022 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 Quote Link to comment
Sandeep Jain 0 Posted March 22, 2023 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 ? Quote Link to comment
10 Comments
Recommended Comments