How about something like this:

if Sheet1.Range("A1").value = 2 then
Sheet2.Range("1:10").entirerow.hidden = false
end if

Note that Sheet1 and SHeet2 are not the worksheet tab names, but the
worksheet code names. If you want to change the worksheet code names, take
a look at the properties for the worksheet in question and change the
variable titled (Name)

HTH,
Barb Reinhardt
"Ram" wrote:

Hi,

In my excel form, I have a field that taked in values from 1 to 5 in
a dropdown,

now for example I select 2 from the dropdown, a series of 10 rows
should get unhidden in another worksheet "Next".

is this possible.

Please help me with a code.

Thanks!