Faster way to name the namebox

Is there any faster way inorder to name all of the nameboxes?
A2-D2 = Question1
A3-D3 = Question2
and so on and so forth, because i got around 2500+ questions.

1_zpsprf9nykp.png

Originally Posted by Andy Pope

You could select the range A2:D2500 and then in the immediate window enter this command. Change range selected to suit your data

Please Login or Register  to view this content.

from workbook ALT+F11 to open vbe
CTRL+G to open immediate window.
paste code and with the cursor on the line with code press enter.

Ty sir it works

Originally Posted by Andy Pope

You could select the range A2:D2500 and then in the immediate window enter this command. Change range selected to suit your data

Please Login or Register  to view this content.

from workbook ALT+F11 to open vbe
CTRL+G to open immediate window.
paste code and with the cursor on the line with code press enter.

What if this one sir?
In data validation:
Dead-Reckoning is sourced on = Question1
What about the estimated position, how can i automatically source it to Question2? So on and so forth, cuz i got around 2500+ questions sir. Thanks
1_zpsk92jjppj.png