How to jump to specific cell
Bob Phillips wrote:
application.goto range("B" & Listbox1.Value)
--
HTH
Bob Phillips
(replace xxxx in the email address with gmail if mailing direct)
"Milax" wrote in message
...
Can anyone help me,
How can I make Excel to jump to specific cell depending on another cell
value. For example if in list box are stored values from 1 to 10 how
can go to column B row (number stored in list box)
Example:
Cell A1=1 --- jump to B1
Cell A1=5 --- jump to B5
Thanks!
Thanks!
|