Quick Question about references

[Mike Winqvist]

Hi


I want to make a script that has a number input that will decide where the script will start. See example below

Please Login or Register  to view this content.

So in C5 I want to put a number, and the the script will use that number instead of (current) "9", to know where to start. Meaning I want two write something like

Rows(startrow:startrow).select

And also

Range( column b and row "startrow").select


How do i write that in VBA
If anyone can assist with this easy question I would be very thankful!!

[VBA Noob]

Maybe

Please Login or Register  to view this content.

VBA Noob

[Mike Winqvist]

Thank you very much! That did the trick!

Love this forum, quick and accurate help!