Assalam-u-Alaikum (Hello) everyone, please help me in excel i have a worksheet i want that when i click on a cell it's value automatically change into 1, than when i click second cell it's value becomes 2, and so on till when i click on 20th cell it's value become 20. i try in private sub worksheet_selectionchange
for i = 1 to 20
selection.value = i
next i
end sub
but it did'nt work please help me
for i = 1 to 20
selection.value = i
next i
end sub
but it did'nt work please help me