Two Easy Questions

T

Trintrin

1. On one of my worksheets if I select so much as one column two hide
it hides my whole worksheet. How can I stop that?

2. In a userform I want to prompt for a row number and have them
either input a number or use irow. what value should I do?

For example, I want it to print out like this for the input of the
number five, or iRow

ws.Cells(iRow, 11).Value = Me.CharityEvent.Value
ws.Cells(5, 11).Value = Me.Buickbox.Value

Thanks
 
D

Dave Peterson

#1. Do you have any merged cells in your worksheet? If yes, what version of
excel are you using? In some versions of excel, when you selected a column that
included merged cells, all the columns in that mergearea are selected, too.

#2. Make a textbox and ask what number they want to use???

dim iRow as long
if isnumeric(me.textbox1.value) then
irow = clng(me.textbox1.value)
else
irow = 5
end if

????
 
T

Trintrin

Hey, i know my post wasn't clear since, I'm new to this stuff, but your
answer was exactly what I was looking for. Thanks so much, it
works!!!!!!!!!!!!!!!!!!!!!!!!!!!!
 
Top