Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
follow hyperlink syntax
THIS QUESTION IS POSTED IN 'ACCESS DATABASE - GENERAL QUESTIONS' ALSO
i am able to use FollowHyperlink to open an excel file, and go to a specific cell, but i want to go to a cell with a specific value, with that value being determined based on a selection (item number) made on an Access form. this is the code i use now in the dblclick event of a text box populated with item numbers. Application.FollowHyperlink "C:\SCHEDULE.xls#'ITEM LIST'!H" & [Item Number] this would work fine if the row numbers coincided with the item numbers, but they don't and i don't want to re-arrange them (1000 rows, 17 columns, many formulas) so i want the syntax for going to a cell based on it's value. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hyperlink will not follow when worksheet changes name | Excel Discussion (Misc queries) | |||
Getting a hyperlink to follow a sort | Excel Discussion (Misc queries) | |||
follow hyperlink? | New Users to Excel | |||
follow hyperlink? | Excel Worksheet Functions | |||
How do I follow a hyperlink by just pressing "enter"? | Excel Discussion (Misc queries) |