Offset with a variable

[Tati123]

Hi guys,
my problem seems very simple but still can't find a solution.
If i have in A1 variable number how can i integrate it into vba offset formula.
Let's say A1=5 and i want that vba goes from B1 by 5 cells down (5 cells comes from A1)...

please SOS

[buran]

Please Login or Register  to view this content.

This will refer to Range("B6"), given that A1=5
Note that you need to take care to not fall outside e.g. negative Row numbers (e.g. negative number in A1) or more than Rows.Count numbers

[Tati123]

Oh god!!! Fantastic!!! thank you so so much! it IS so simple but it's not written anywhere! thank you so much again!

[buran]

it IS so simple but it's not written anywhere!

well
https://msdn.microsoft.com/en-us/VBA...property-excel

[Tati123]

Well, that doesn't seem so easy as your answer

Buran, if i don't stop just at selection a cell but by the end of macro i should have 4 cells selected from the one which was offset?

[buran]

Note that in VBA you almost NEVER need to select anything (there are only few notable exceptions).
It's not completely clear what you [want to] do, but one way to reference 4 cells down starting from B6

Please Login or Register  to view this content.

As I said it's unclear what you want to do, so this is just a suggestion