Active Cell Row Determined By Another Cells Value +1

[Ourkid123uk]

Hi guys,


I have the following VBA;

Please Login or Register  to view this content.

I need some code that rather than references Row 13 as above, its gets the Row number by using the value in Cell F1 +1.


So


Example 1)

If Cell F1 = 10

then i want the VBA code above to use this logic;

If ActiveCell.Address = "$Q$11" Then


or


Example 2)

If Cell F1 = 8

then i want the VBA code above to use this logic;

If ActiveCell.Address = "$Q$9" Then


How do i create this VBA code If Statement?



Any help appreciated, thank you!

[6StringJazzer]

Please Login or Register  to view this content.

This assumes that either:

• This code is in the worksheet containing the cell F1, or
• The worksheet containing the cell F1 is the ActiveSheet

[Ourkid123uk]

Brilliant! Works like a charm

Feedback and positive Rep left!

[6StringJazzer]

Glad to hear it, and thanks!