Why Range("A1") in between?

mayankgo

New Member
Joined
Oct 11, 2017
Messages
10
Code:
    ActiveCell.Offset(-3, 1).Range("A1").Select

I recorded a relative macro and it had Range in between, if I remove that code still flows. Why is that so?
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
I'm not really sure I understand your question but that line just selects a cell in the worksheet.
Without that line the cell would not be selected but, depending on the rest of your code, that may not make any difference.
If you need more than that we would need to see the whole code, have an explanation of what your are trying to achieve and also know what is on your worksheet and where it is on that worksheet.
 
Upvote 0
Code:
    ActiveCell.Offset(-3, 1)[B][COLOR="#FF0000"].Range("A1")[/COLOR][/B].Select

I recorded a relative macro and it had Range in between, if I remove that code still flows. Why is that so?
The Range("A1") is a relative reference (I think I am saying that correctly) starting at the ActiveCell.Offset(-3, 1) cell... since it is A1, it is, in fact, the same cell as ActiveCell.Offset(-3, 1), so it is not needed.
 
Last edited:
Upvote 0

Forum statistics

Threads
1,223,893
Messages
6,175,249
Members
452,623
Latest member
Techenthusiast

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top